EinhugurSqlite.PreparedStatement Class (console safe)
Provides the API for working with prepared statements. Use Database.Prepare to create a EinhugurSqlite.PreparedStatement.
A prepared statement is preferred and safest way to execute SQL statements that need parameters. Inserts, Delete and Edits for example should use prepared statement.
Note:Parameters in the Xojo default implementation are zero based while in the Einhugur SQLite plugin the parameters are one based.
Reason for this is to seamlessly support SQLite numbered parameters where same parameter can apply more than once in your SQL statement.
For example: insert into Team (Name, Coach, City) values (?1,?2,?2)
Object
PreparedStatement
class EinhugurSqlite.PreparedStatement
Constructors
Methods
Bind (console safe) | Binds a double value for the prepared statement. |
Bind (console safe) | Binds a Integer value for the prepared statement. |
Bind (console safe) | Binds a String value for the prepared statement. |
BindBlob (console safe) | Binds a Blob value for the prepared statement, using MemoryBlock to pass in the BLOB value. |
BindBlob (console safe) | Binds a Blob value for the prepared statement, using string to pass in the BLOB value. |
BindInt64 (console safe) | Binds a Int64 value for the prepared statement. |
BindNull (console safe) | Binds a SQL Null value for the prepared statement. |
BindZeroBlob (console safe) | Binds a zero BLOB for the prepared statement. |
SQLExecute (console safe) | Executes the prepared statement without returning result. |
SQLExecuteScalar (console safe) | Executes the prepared statement and returns the value from the first column of the first row. This functions is to be used for when needing only single value result. |
SQLSelect (console safe) | Executes the prepared statement, returning result Recordset. |
Supported Platforms:
macOS Cocoa 32 bitmacOS Cocoa 64 bitWindows 32 bitWindows 64 bitLinux 32 bitLinux 64 bitLinux ARM 32 bitUnsupported Platforms:
macOS Apple Silicon