Subject Re: [firebird-support] Savepoints inside SPs and Triggers
Author Martijn Tonies
Hi,

> >HB> "User savepoints (alternative name nested transactions) provide a
> >HB> convenient method to handle business logic errors without needing to
roll
> >HB> back the transaction. Available only in DSQL."
> >
> >
> There's already a mechanism for undoing part of a stored procedure using
> code blocks and exceptions. That's a cleaner way than savepoints.

Is that the BEGIN..END stuff? 'Cause if so, I don't think a whole lot
of people actually know about this :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com