Execute queries, create parameterized queries, interact with recordsets, get and set parameter values, and perform other advanced operations.
Creates a structured
SQL query
statement that accepts a value or array of values.
Executes an SQL query and returns a reference.
Retrieves the data at the
column index
of the record in the Recordset that you specify.
Retrieves the next Recordset in a multi-Recordset query.
Retrieves the data in the Recordset you specify.
Frees an object by closing its
reference.
Retrieves the value of the parameter you specify.
Points the cursor to the next record in the Recordset you specify with the
reference
input.
Points the cursor to the previous record.
Points the cursor to record
n
in the Recordset.
Returns a database NULL value.
Sets the value of the parameter at the index you specify with the
parameter index
input.