How can we pass our own SQL Commands within a transaction?
Posted: Wed 01 Dec 2004 20:54
Hi,
I want to pass some of my own commands to SQL Server with in a transaction how can i do that?
Im using nested datasets in a ClientDataset
eg.
upon ClientDataset.ApplyUpdates
the following happens auto.
begin trans
Insert into Master ....
Insert into Detail ....
if CanSave = False then Rolback // This is not auto
commit
I want to pass some of my own commands to SQL Server with in a transaction how can i do that?
Im using nested datasets in a ClientDataset
eg.
upon ClientDataset.ApplyUpdates
the following happens auto.
begin trans
Insert into Master ....
Insert into Detail ....
if CanSave = False then Rolback // This is not auto
commit