Prepared Statements and Transactions

[NineBerry]

Hi

I have noticed, that when a transaction is committed, all querys or sql-statements that had been prepared within that transaction, are not prepared any longer.

Is this a restriction by the Firebird server or is there any way to circumvent that behavior and keep statements prepared for use in multiple transaction (sequentially)?

Thanks in advance.

[Plash]

This is the restriction of InterBase/Firebird. Any statement is linked to a transaction and can be used only inside this transaction.

To keep statements prepared you can use CommitRetaining instead of Commit, or use several transactions.

[NineBerry]

Thank you for the information