Icon Prepared Property

property Prepared: Boolean

Usage

Use the Prepared property to determine if an SQL statement is already prepared for execution. If Prepared is True, the SQL statement is prepared, and if Prepared is False, the SQL statement is not prepared. While an SQL statement need not be prepared before execution, execution performance is enhanced if the SQL statement is prepared beforehand, particularly if it is a parameterized SQL statement that is executed more than once using the same parameter values.

Information An application can change the current setting of Prepared to prepare or unprepare an SQL statement. If Prepared is True, setting it to False calls the UnPrepare method to unprepare the SQL statement. If Prepared is False, setting it to True calls the Prepare method to prepare the SQL statement.
Image