Overview - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

PreparedStatement

Database Prepared Statement Module

 

The Prepared Statement Module

A PreparedStatement Module's Exported Commands

The Prepared Statement Module

• 

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.

A PreparedStatement Module's Exported Commands

Close

Execute

GetOptions

NextResult

SetOptions

 

 

 

See Also

Database

Database[Connection][CreatePreparedStatement]

Database[Statement]

Database[usage]

 


Download Help Document