Hi,

At July 1, 2003, 10:26, Helen Borrie wrote:

> At 12:58 PM 1/07/2003 +0000, you wrote:
>>Hi,
>>Can anybody tell me, how to use a transaction in a SP.
>>As, it is done in SQL server i.e. begin/commit/Rollback transaction

> Firebird doesn't support embedded transactions (Firebird sysdba's like to
> sleep at home!)

> You can embed procedures inside other procedures, though, and return custom
> exceptions to the caller procedure.

> Coming in a future release (possibly 1.6) will be savepoints, another way
> to condition whether a block of work inside a procedure will be carried
> through or undone.

I think savepoints have been introduced in FB 1.5.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)