Thanks Jason. here is what I'm doing:

with qry1 do
begin
close;
if (not prepared) then
begin
prepare;
end
open;
first;
while (not EOF) do
begin
// do some work
next;
end
close;
unprepare;

Is this correct? It does not seem to be releasing the memory.

TIA,

Kevin Joseph
kjoseph@...

On Thu, 26 Jul 2001, Jason Wharton wrote:

> You need to do an Unprepare in order to make it release all of its dynamic
> resources.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Kevin D. Joseph" <kjoseph@...>
> To: <ibobjects@yahoogroups.com>
> Sent: Thursday, July 26, 2001 3:04 PM
> Subject: [IBO] tib_cursor memory usage/allocation
>
>
> >
> > Hi all,
> >
> > I am trying to get some information about how memory is
> > used/allocated by the tib_cursor. When I prepare the cursor I see memory
> > usage increase between 4 and 20 K depending of the cursor. When I close
> > the cursor no memory is released. Is this the way it should be? If so,
> > short of building and freeing the cursors on the fly is there a way to
> > free the memory?
> >
> > TIA,
> >
> > Kevin Joseph
> > kjoseph@...
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>