SQLCommandMBS.CommandText as string

Var s as new SQLCommandMBS(nil, "select * from test")

MsgBox s.CommandText

Use the CommandText method to return the command text declared in SACommand constructor or setCommandText method.

All text strings sent to the plugin must have a defined encoding. Else the internal text encoding conversions will fail.
(Read and Write property)

SQLCommandMBS.CommandType as Integer

One of the following values from SACommandType_t enum:

• kCommandTypeUnknown Command type is not defined. Library will detect command type automatically when needed.
• kCommandTypeSQLStmt Command is an SQL statement.
• kCommandTypeSQLStmtRaw Command is an SQL statement that mustn't be interpreted by SQLAPI++.
• kCommandTypeStoredProc Command is a stored procedure or a function.

SQLCommandMBS.Connection as SQLConnectionMBS

When you set the connection on a command object that already has associated connection, the previous association will be correctly discarded (with closing opened command if needed) and new connection will be set.

If you attempt to call any method on a SACommand object that requires database access with no valid connection, an error occurs.
(Read and Write property)

SQLCommandMBS.FieldCount as Integer

FieldCount method returns the number of fields created implicitly after the command execution if a result set exists.

A field is represented by SAField object. You can get field value and description using Field method.
(Read only property)

SQLCommandMBS.Fields as Dictionary

This dictionary should help for debugging to inspect all fields and their text value.
(Read only property)

SQLCommandMBS.hasCache as Boolean

(Read only property)

SQLCommandMBS.isBOF as Boolean

Set to true when running the query and when FetchFirst succeeds.
Otherwise false.
(Read only property)

SQLCommandMBS.isEOF as Boolean

True if we are at the end of the recordset, e.g. FetchNext failed.
Set to false by Execute.

We set it to true, when something goes wrong, so Xojo's RecordSet and RowSet end looping.
We can only know, that we are not at the last one, if FetchNext internally failed to get the next record.
(Read only property)

SQLCommandMBS.isExecuted as boolean

(Read only property)

Some examples using this property:

• /SQL/SQL Unit Tests

SQLCommandMBS.isExecuting as Boolean

You only see this true if you use threaded queries and look on the property from another thread.
(Read only property)

SQLCommandMBS.isOpened as boolean

(Read only property)

Some examples using this property:

• /SQL/SQL Unit Tests

SQLCommandMBS.isResultSet as boolean

Returns true if the result set exists; otherwise false.
(Read only property)

Some examples using this property:

• /SQL/Microsoft SQL Stored Procedure
• /SQL/MySQL Connect via SSH
• /SQL/SQL Unit Tests
• /SQL/SQLDatabaseMBS Microsoft SQL Server Data Types
• /SQL/SQLDatabaseMBS Microsoft SQL Stored Procedure
• /SQL/SQLite Benchmark vs REALSQLDatabase
• /SQL/SQLite Display Schema

SQLCommandMBS.Options as Dictionary

For debugging, it may be useful to inspect options in debugger.
(Read only property)

SQLCommandMBS.ParamCount as Integer

ParamCount method returns the number of parameters created explicitly by using CreateParam method or (if parameters were not created before) creates them implicitly (can query native API if needed and therefore can throw exception on error) and returns the number of created parameters.

Command parameter is represented by SAParam object. You can look SAParam objects through and assign their values with Param and ParamByIndex methods.
(Read only property)

Some examples using this property:

• /SQL/SQL Unit Tests

SQLCommandMBS.Parameters as Dictionary

This dictionary should help for debugging to inspect all parameters and their text value.
(Read only property)

SQLCommandMBS.RowsAffected as Integer

Var con as SQLConnectionMBS // your connection

Var sql as string = "UPDATE Test SET MyField=1"
Var c as new SQLCommandMBS(con, sql)

c.Execute

MsgBox str(c.RowsAffected)

(Read only property)

SQLCommandMBS.Tag as Variant

Var c as SQLCommandMBS // your command object

// store reference to window/control, so we have it available in events
c.Tag = self

You can store here whatever you like.
(Read and Write property)