IDBStatement Interface

Represents a prepared SQL statement that can be parameterized and executed against the database.

Remarks

Obtain an instance by calling IDBConnection.CreateStatement. Set the SQL text with SetSQLCommand and bind parameter values with SetParams, then call Execute for DML statements or ExecuteQuery for SELECT statements.

Syntax

Unit: Aurelius.Drivers.Interfaces

IDBStatement = interface(IInterface);

Methods

Name	Description
Execute	Executes the SQL DML statement and returns the number of rows affected.
ExecuteQuery	Executes the SQL SELECT statement and returns a forward-only result set.
SetParams	Binds the parameter values that will be substituted into the SQL statement.
SetSQLCommand	Sets the SQL text of the statement.