Thanks, Paul. Now I've got something to read while I watch the Blazers playoffs:-).

--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> Hello Homer,
>
> > Is it possible to use transactions in a stored procedure? I've looked it up in Helen's book and done the Google thing, but I am not able to make it work.
>
> Starting with Firebird 2.5, yes. For details, read the Release Notes:
>
> http://www.firebirdsql.org/rlsnotes/Firebird-2.5.0-ReleaseNotes.pdf
> (chapter Procedural SQL, sections Autonomous Transactions and New Extensions to EXECUTE STATEMENT)
>
> -or-
>
> http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-auton
> http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-exctstmnt
>
>
> Cheers,
> Paul Vinkenoog
>