At 09:41 PM 2/11/2002 +0300, Lev Assinovsky wrote:

>I am not sure API memory management is clean.
>I use about 150 different selects in non-stop client.
>For few days the size of my application increased from 2 Megs to 5.

What you haven't shown in your pseudo-code is any call
that releases the request. Prepared requests are cached
until they are released or the connection ends. The
call isc_dsql_release which takes a status vector and
a prepare statement handle as arguments is what you need.


Regards,

Ann
www.ibphoenix.com
We have answers.