Subject Re: Savepoints with IBX and Delphi 5
Author Adam
--- In firebird-support@yahoogroups.com, "Gustavo" <gusm@...> wrote:
>
> Hello:
>
> I use Delphi 5, FireBird and IBX. I have IBX 5.04, wich I is the newest
> version of IBX wich works with Dephi 5.
>
> I need to use savepoints but this version of IBX doesn´t have any
function
> to work with them. I know that there are newer versions of IBX (for
example
> 6.08 or others) which have 3 TIBTransaction methods to work with
savepoints
> (StartSavepoint, RollbackSavepoint and ReleaseSavepoint) but these
versions
> of IBX are for Delphi 6, 7 or 8.
>
> My question is: Does anyone know how can I use savepoints with Delphi 5
> inside a Transaction started with StartTransaction?

I am pretty sure you can just send the DML command through a TIBQuery
or TIBSQL component.

SAVEPOINT BLAH
ROLLBACK TO BLAH
RELEASE SAVEPOINT BLAH [ONLY]

Adam