Hello,

On Sun, 11 Jul 2004 23:20:50 +0200,
Faultier wrote:

> the function isc_dsql_allocate_statement() will allocate a statement
> handle and the function isc_dsql_prepare() will set the statement handle
> to refer to the parsed format.
> Do I have to call isc_dsql_free_statement(...DSQL_drop) and
> isc_dsql_allocate_statement() again for another call to isc_dsql_prepare() ?

To prepare another statement, after one was prepared, you have to:

> isc_dsql_free_statement(...DSQL_drop)
> isc_dsql_prepare()

That is:

> function sequence:
> isc_dsql_allocate_statement()
> isc_dsql_prepare()
> isc_dsql_execute()
> isc_dsql_free_statement(...DSQL_drop)
> isc_dsql_prepare() // ???
> isc_dsql_execute()
> isc_dsql_free_statement(...DSQL_drop)

--
Best Regards,
Olivier Mascia