Hi Everyone,

I have multiple DELETEs, UPDATEs in some of my SPs. For example

CREATE PROCEDURE DO_STUFF
AS
BEGIN

DELETE FROM USERS WHERE ....

DELETE FROM ROLES WHERE...

UPDATE LOG WHERE ...

END

Are all these statements run in the same transaction when I can the SP? Or do I have to explicitly put BEGIN...COMMIT TRAN in the SP?

Can someone please show me a small example of nested transactions in Firebird 2.0(I'm mostly interested in the SQL syntax)?

Thank you in advance,
Vlad




____________________________________________________________________________________
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265

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