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 ?


Stephen






[Non-text portions of this message have been removed]