Subject Re: 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
> >use the isc_dsql_prepare() function, however it needs
> >a "transaction" handle to work.
> Do you know that Firebird allows muliple concurrent transactions
> inside one connection?
> >In ADO I can prepare a statement then feed it and execute it in
> >context of a given transaction (chosen only at execution time).
> >it possible to do so with Firebird ?
> Yes. Prepared statement can overlive the transaction where it
> been prepared. But this is not safe if you frequently change
> metadata.
> SY, Dimitry Sibiryakov.

What do you call exactly "metadata" ? tables / indexes ?