BrightSign Object Reference Manual (FW 5.1) - Manual (Page 157)

149
roSqliteStatement
This object is created by calling the CreateStatement() method on an roSqliteDatabase object.
Interfaces: ifSqliteStatement
The ifSqliteStatement interface provides the following:
Note: All bind methods return True upon success.
•
BindByName(associative_array As Object) As Boolean: Binds the SQL variable(s) using the names
contained in the SQL statement.
• BindByOffset(associative_array/enumerable As Object) As Boolean: Binds the SQL variable(s)
using the index contained in the SQL statement. If passed an associative array, this method will convert the keys of
the associative array into numeric offsets when binding. If passed an enumerable object (e.g. roArray), it will bind
the values of the enumerable in the order that they are stored.
• BindText(variable/index As Object, value As String) As Boolean: Binds the SQL variable
indicated by the name or index parameter to the passed string value.
• BindInteger(variable/index As Object, value As Integer) As Boolean: Binds the SQL variable
indicated by the name or index parameter to the passed integer value.
• Run() As Integer: Runs the SQL statement immediately and waits for the integer result. The following are
possible integer result codes:
o 100: Statement complete
o 101: Busy
o 102: Rows available
• RunBackground() As Integer: Runs the SQL statement in the background. You can use
roSqliteDatabase.SetPort() to set a message port that will receive an roSqliteEvent message at a later point. The
RunBackground() call will result in an integer transaction ID, which will appear in the roSqliteEvent message that
matches the transaction.