Ghanshyam 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

AFAIK, in FB 1.0 you can't.

SP is already inside a transaction, and it cannot start another one...

I'm not sure about version 1.5, I think there is a mechanism like
Checkpoints, so it can do exaclty what you want (instead of starting new
trans. you declare a checkpoint, and you can later rollback all changes
made since it was declared - so it basically almost the same as starting
a new trans.)

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net