Applies to
TIB_Statement

Declaration
Procedure Unprepare;

Description
This method will close, unprepare and free up the InterBase statement handle obtained upon allocation.

I now have the connection caching the statement handles so it is possible that allocating and deallocating a statement will reuse a handle already acquired.

This also frees all of the input and output column buffers.

For datasets it also deallocates all of its auxillary statements and cursors.

One caution is that this won't necessarily clear out all input parameter values if you happen to prepare a new statement that has an input parameter with the same name as the previous statement.