How can we pass our own SQL Commands within a transaction?

[User]

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

[Ikar]

Such behavior is impossible using ClientDataSet.