Subject Re: [firebird-support] Savepoints inside SPs and Triggers
Author Helen Borrie
At 10:49 AM 16/12/2003 -0200, you wrote:
>** Originally posted in fbdevel, but moved here (the right place) **
>
>People,
>
>Someone from Borland posted in my discussion list that in IB 7.1 you
>can use SavePoints inside StoredProcs and Triggers and he claims that
>the implementation of Firebird SavePoints is incomplete because you
>can't do that with FB.
>
>As far as I know there is no transaction control inside SPs and
>Triggers, so I'm wondering if that he said is really true. Can anyone
>confirm that to me ?

To quote the release notes (Nickolay Samofatov):

"User savepoints (alternative name nested transactions) provide a
convenient method to handle business logic errors without needing to roll
back the transaction. Available only in DSQL."

You can download your own copy of the release notes from the ibphoenix
site, which is now back on-line.
/helen



>[]s
>Carlos
>http://www.warmboot.com.br
>FireBase - http://www.FireBase.com.br
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/