Subject | Re: [firebird-support] Savepoints inside SPs and Triggers |
---|---|
Author | Martijn Tonies |
Post date | 2003-12-16T17:10:55Z |
Hi,
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
> >HB> "User savepoints (alternative name nested transactions) provide aroll
> >HB> convenient method to handle business logic errors without needing to
> >HB> back the transaction. Available only in DSQL."Is that the BEGIN..END stuff? 'Cause if so, I don't think a whole lot
> >
> >
> There's already a mechanism for undoing part of a stored procedure using
> code blocks and exceptions. That's a cleaner way than savepoints.
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