Frees the resources allocated for a previously prepared query.

Syntax:

procedure UnPrepare;

Description:

Call UnPrepare to free the resources allocated for a previously prepared query on the server and client sides.

Preparing a query consumes some database resources, so it is good practice for an application to unprepare a query once it is done using it. The UnPrepare method unprepares a query.

When you change the text of a query at runtime, the query is automatically closed and unprepared.