Page 1 of 1

Applying only updates and inserts

Posted: Mon 31 May 2010 09:41
by Ludek
I have a tmsquery in cached updates mode and i would like to apply only the updates and inserts into database (i need to apply other changes before the deletions in this msquery, but after inserts and modifications)
i'm thinking about onupdaterecord with uaSkip - but - i would find some solution like ApplyUpdates([ukInsert, ukModify]) more friendly to programmer. would you mind including it in some next version of sdac?

and a question: is it safe to call commitupdates for one query twice? (commitupdates, although everything has been already committed)

Posted: Tue 01 Jun 2010 14:56
by Dimon
Ludek wrote:i'm thinking about onupdaterecord with uaSkip - but - i would find some solution like ApplyUpdates([ukInsert, ukModify]) more friendly to programmer. would you mind including it in some next version of sdac?
Ok, we will add this functionality in the next SDAC build.
Ludek wrote:and a question: is it safe to call commitupdates for one query twice? (commitupdates, although everything has been already committed)
Yes, it is safe.

Posted: Tue 01 Jun 2010 21:55
by Ludek
Thanks for both!