At July 1, 2003, 09:58, Ghanshyam wrote:

>>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
>>
>>

Daniel Rail wrote:

>For the moment, you can't. But, you can submit it as a request for a
>later version of Firebird.
>

Much later, I hope. Stored procedures already include automatic undo on
error which can
be caught and customized as needed. The design goal of stored
procedures was a "black
box:" which produced some desired result through a mechanism that the
program did not
need to understand. They should not change the environment of the
client application.

Regards,


Ann