Hi,

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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)