Subject Re: [firebird-support] Re: Nested transaction and prepare ??
Author Daniel Rail

At March 25, 2004, 16:21, benedicte_asselin wrote:

>> >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.
>> 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
> the
>> >context of a given transaction (chosen only at execution time).
> Is
>> >it possible to do so with Firebird ?
>> Yes. Prepared statement can overlive the transaction where it
> has
>> been prepared. But this is not safe if you frequently change
>> metadata.
>> SY, Dimitry Sibiryakov.

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

The metadata is the structure of the database(i.e.: table structures,
field definitions, indices, triggers, stored procedures, etc...)

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (