When you explicitly call Unprepare it also deallocates the statement handle
that is being held to use your query and any internal statement handles as
well.

I highly recommend that utilize explicit Unprepare calls in your application
if appropriate. In my apps I usually am creating and destroying form
instances with the data aware components right on them so it takes place
automatically.

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, April 03, 2001 1:31 AM
Subject: Re: [IBO] Unprepare question


> Nico,
>
> > I'm just wondering when is the right time to unprepare a query ?
> Whenever your program doesn't expect to need it any more.
>
> >At the end of your application ?
> Then it happens automatically
>
> >Every time a form is closing ?
> if you set "Action:=caFree" in your OnClose procedure and have your query
> on the form rather than in a data module, this will happen automatically.
>
> >Because I guess when a query stays prepared, it takes resources on the
> server side??
> Does it? The server has to prepare the statement, but once prepared I
> thought it would only consume workstation resources (unless your programs
> run on the server, of course). Any comments from the masters of IBO?
>
> Set