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