Re: Recovering from an updatebatch error with a clone

damian marquez <dmarquez34@xxxxxxxxxxx> wrote:
> I am basically using batchoptimistic locking in a master/detail
> scenario to cache changes in memory.
> When posting, I start a transaction, try to run updatebatch and in
> case of an error (let's say when
> somebody else modified the same record) I try to recover using a
> clone... but it seems the same old
> status is preserved, so if i try to save data again, same problem will
> happen...

I was watching the threads that recommend SaveToADOStream which exists
in BetterAdo... but when I load back the data I somehow cannot post it back
to the database with updatebatch... Found no solution so far... Ideas?

--
Have you seen Marillion's Marbles? Visit www.marillion.com and get in
touch with the most amazing music...


.

Relevant Pages

  • Recovering from an updatebatch error with a clone
    ... cache changes in memory. ... When posting, I start a transaction, try to run updatebatch and in case of ... // here goes the transaction. ...
    (borland.public.delphi.database.ado)
  • Re: BeginTrans
    ... that by caching writes to the server until you updateBatch ... >need to use a transaction to keep master and detail changes together. ... The transaction gets cleaned up on the server side but not on the client side. ...
    (borland.public.delphi.database.ado)
  • Re: Ado UpdateBatch vs CommitTrans
    ... >It seems in short me that UpdateBatch has the same function of CommitTrans. ... if you want to be able to apply All changes and if that fails rollback all ... changes then you need to use a transaction ... >- why when it calls RollBackTrans it is not also called CancelBatch? ...
    (borland.public.delphi.database.ado)
  • Re: Ado UpdateBatch vs CommitTrans
    ... >>UpdateBatch to call the method after the post of the record so that the ... >>changes are written on the server? ... > not be using BatchUpdateMode ... > changes then you need to use a transaction ...
    (borland.public.delphi.database.ado)