BorlandTalk.com

Slavisa Cicovic · Guest

BlankOn the SERVER side I have : t1, t2, t3: TSQLTable,
they are linked via pv1, pv2, pv3: TDataSetProvider to
cds1, cds2 cds3: TClientDataSet on the CLIENT side.
Is it posible to make
cds1.ApplyUpdates;
cds2.ApplyUpdates;
cds3.ApplyUpdates;
in one transaction.

Bill Todd (TeamB) · Guest

Possible but not easy. There is a example in the utilities unit of the
MIDESS project on Source Forge. There is also a paper by Dan Miser on
BDN that describes this.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Roberto Novakosky · Guest

I didin't try but i think is possible, but i think dificult with
provider/cds. The way: you must do a unique SET TRANSACTION to that
Client and to all INSERT, UPDATE you must to use the same trans, INSERT
MYTRANSACTION INTO..., UPDATE MYTRANSACTION YOURTABLE... but you will do
the commit manually at the end of all your changes.
To do this easily, a think that the best way is using a service from de
app server (Web Services). From the service you can control manually
your unique commit more easily. Maybe, the compnent RxMemory (RxLib) can
help you to cache on the client side the records to do the updates at
the same time by a unique SQLQuery.

Roberto Novakosky