Online Help

A PreparedStatement Module represents an arbitrary SQL statement that contains parameters. These parameters can be replaced with values at execution time. This allows the same statement to be re-used. Depending on the underlying implementation of PreparedStatements, it may be more efficient to repeatedly use a PreparedStatement than to pass strings into a Statement module.

PreparedStatement modules are created using the CreatePreparedStatement command. This command takes a parameterized string of SQL to prepare. A call to Execute accepts values, which are inserted into the string to form an SQL statement.

The string passed into CreatePreparedStatement must be a standard SQL string parameterized with "?" (with "?" in place of values). These "?" will be replaced with the values given to Execute .

Except for the differences in creation and execution, PreparedStatement modules are identical to Statement modules. The exported members NextResult , SetOptions , GetOptions , and Close in PreparedStatement and Statement modules behave identically.

For information on using the Database package, see the usage page.