Subject Re: [IBO] Unprepare question
Author Svein Erling Tysvær

> 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?