You are right. That was the first thing I tried and it didn't work. So I was trying to use isc_start_savepoint, etc., but when I call GetProcAddress with 'isc_start_savepoint', I got an error. Apparently the fbclient.dll (renamed gds32.dll) doesn't have this function (and the others to work with savepoints). But, after that I found that I was calling "SAVEPOINT BLAH" with the right Transaction but with the wrong DataBase. I fixed this and now everything works OK.

Another question. Do I have to call RELEASE SAVEPOINT BLAH, or when I rollback or commit the Transaction, every savepoints are automatically released?

Gustavo

----- Mensaje original -----
De: Adam
Para: firebird-support@yahoogroups.com
Enviado: Jueves, 24 de Agosto de 2006 20:23
Asunto: [firebird-support] Re: Savepoints with IBX and Delphi 5

--- 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







++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links









__________ Información de NOD32, revisión 1.1721 (20060823) __________

Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com




[Non-text portions of this message have been removed]