Hello,

> > Why are we closing all prepared statements automatically
> > at commit execution ?
> >
> > Firebird seems to support spanning the prepared statements
> > over several transaction.
>
> Does it? As I see from isc_dsql_prepare(...) you have to pass
> transaction handle. If the statement can survive commit, why should I
> pass transaction handle? So, does it support prepared statements over
> commit?

Yes, the transaction handle seems to be useless in isc_dsql_prepare()
but if you read the API documentation it says that the prepared
statements survive to the entire session.

You can try a small test case and you'll convince yourself.

Bye.

--

+--------------------------+
| Alejandro Alberola Arias |
| Boix i Oltra, S.L. |
| email: alberola@... |
+--------------------------+