Subject Re: how to use a transaction in SP
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@u...>
wrote:
> Helen,
>
> > >I think savepoints have been introduced in FB 1.5.
> >
> > Not yet. Currently withdrawn by Nickolay for more work, AFAIU.
>
> All issues are fixed in the v1.5 codebase, so it will be included in
the
> final release.

Dmitry, AFAIR explicit savepoint usage was allowed on client side
only, not in SP. Am I wrong? To be honest, during 8 years with IB/FB I
never wanted transactions control in SP. MSSQL connections are just
tubes to send statements and get data, they don't really control
processing, in FB we can control absolutly all from client. And if we
need to handle exceptions on server side, we have WHEN handler and
implicit savepoints usage controlled by begin-end blocks.

Best regards, Alexander.