Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

DB2MBS.SQLExecDirect(cmd as SQLCommandMBS, text as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 13.2 Yes Yes Yes Yes No
Function: Executes an SQL command directly without any preprocessing in the plugin.
Example:
dim cmd as new SQLCommandMBS // your command
dim con as new SQLConnectionMBS // your connection
dim api as DB2MBS = con.NativeAPI

// now use an API function
const sql = "some sql command"
api.SQLExecDirect cmd, sql
Notes: Lasterror is set.

Feedback, Comments & Corrections

DB2MBS.SQLRowCount(cmd as SQLCommandMBS) as Int64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 13.2 Yes Yes Yes Yes No
Function: Queries the affected number of rows for the last operation.
Notes: Lasterror is set.

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS Xojo Plugins