At 09:26 AM 28/11/2008, you wrote:

>Hello All
>
>How can I set a transaction savepoint in TIB_Transaction and than
>rollback to this savepoint or remove it.
>
>Using D2007, FB 1.5 and IBO 4.8.7

Savepoints are not attributes of the TPB: the savepoint mechanism exists within the context of an uncommitted transaction that is already running. If you are using explicit transactions, Autocommit false and the correct client library, the SAVEPOINT statements should be expected to work using run-time-created and destroyed ib_dsqls executed within your transaction's context. For syntax, see detailed documentation in Fb 1.5 release notes, in the chapter "SQL Language Enhancements".

Note that TIB_Transaction has its own (client-side) Savepoint method that has nothing to do with SQL savepoints. DO NOT CALL THIS. It commits the transaction using CommitRetaining and is definitely not sympathetic with SQL SAVEPOINT !!!! (In any case, IB_Transaction's Savepoint method does not take arguments.)

Helen