Subject Nested transaction and prepare ??
Author benedicte_asselin

I would like to realize numerous requests on a Firebird database.
Each request may be repeated a great deal of times, so I'd like to
use the isc_dsql_prepare() function, however it needs
a "transaction" handle to work.
In ADO I can prepare a statement then feed it and execute it in the
context of a given transaction (chosen only at execution time). Is
it possible to do so with Firebird ?
If I cannot prepare the statement outside of a transaction, can I
nest transactions ? or use some commit points so that I could
prepare all my requests once at the very beginning of my transaction
then, execute them as needed, commiting data after each set of
transactional commands.