> Could someone please clarify the concept of transaction termination.
>
> In my understanding, transactions are explicitly started in
> Delphi with the command 'StartTransaction' and are ended with 'Commit'.
>
> So when I write an invoice transaction to a table it is as follows,
>
> Commit ; StartTransaction ;
>
> Save data using a stored procedure ....
>
> Commit ;
>
> The invoice line item is written to the table.
>
> During this process a triggers executes, calling a stored
> procedure, and the quantity on hand in the stock master file is updated.
>
> The stock masterfile in turn uses a trigger to append a cost
> change history log table.
>
> The question is, are all the triggers and stored procedures that
> are executed down through multiple tables all contained within
> the one transaction ?

yes and if the transaction is rolled back, all that "stuff" is also rolled
back.
Alan

>
>
> Stephen