Subject Re: [IBO] Unprepare question
Author Jason Wharton
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

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

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <>
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