Combining OnUpdateRecord & options.batchsize?

[Ludek]

Hi, i would like to have my own UpdateRecord handler (= do the standard action + something additional) and also apply the resulting changes grouped to some batch. Is there a way?
Thanks, Ludek.

[azyk]

On using BATCH, after the TMSQuery.Execute method this BATCH is executed completely on the server. Therefore we can't control BATCH behavior during its execution on the server.

[Ludek]

I'm sorry, i don't understasnd now...
Other example:
Now, I can use my custom insert command in sqlinsert property of tmsquery (and applyupdates with updatebatchsize > 1 sends all of them in one batch to sql server). I would like to (slightly) customize the insert command for each saved record and save all the per-record-customized commands in one batch.

Just like sdac is connecting the same commands to one batch, it could perhaps connect MODIFIED commands to one batch(?)

[Ludek]

perhaps beforeupdateexecute... I'll try it.

[Ludek]

Hmh, also hardly usable. this event contains already the connected command with all the parameteres of all the commands merged... Not simple to change the parameters and even harder to change something in the sql text... I even don't know, whether is changing of the sql text allowed...
Some better idea to do my task?

[AlexP]

Please clarify, what do you want to modify: the SQL query text or parameter values?

[Ludek]

sometimes this, sometimes that
but i gave up, i'm just setting updateaction := uaApplied and doing all the batch concatenation myself...