jamesg@... wrote:

> This will increase memory size very quickly:
>
> isc_attach_database
> for (int n = 0; n < 2000; n++)
> isc_start_transaction
> isc_dsql_allocate_statement
> isc_dsql_prepare
> isc_dsql_describe
> isc_dsql_execute
> while (isc_dsql_fetch)
> isc_dsql_free_statement
> isc_commit_transaction
> isc_detach_database
>

What are you passing in isc_dsql_free_statement - drop or close? Have you
tried closing and then dropping?

isc_dsql_free_statement(@StatusVector, @FStmtHandle, DSQL_Close);
isc_dsql_free_statement(@StatusVector, @FStmtHandle, DSQL_Drop);



Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further