Devart Forums

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.

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.

Thank you for the information