Icon Prepare Method

procedure Prepare

Usage

Call the Prepare method to have ElevateDB allocate resources for the execution of a script, compile the script, and perform the process of setting up the script for execution. The script is specified via the SQL property.

ElevateDB automatically prepares a script if it is executed without first being prepared. After execution, ElevateDB unprepares the script. When a script will be executed a number of times, an application should always explicitly prepare the script using the Prepare method to avoid multiple and unnecessary prepares and unprepares.

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

Information When you change the SQL property, the current script is automatically closed and unprepared.
Image