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

SQLCommandMBS.kCommandTypeSQLStatement = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the constants for the command type.
Notes: Command is an SQL statement.

Feedback, Comments & Corrections

SQLCommandMBS.kCommandTypeSQLStatementRaw = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the constants for the command type.
Notes: Command is an SQL statement that mustn't be interpreted by SQLAPI.

Feedback, Comments & Corrections

SQLCommandMBS.kCommandTypeStoredProcedure = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the constants for the command type.
Notes: Command is a stored procedure or a function.

Feedback, Comments & Corrections

SQLCommandMBS.kCommandTypeUnknown = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the constants for the command type.
Notes: Used by default. Library detects command type automatically.

Feedback, Comments & Corrections

SQLCommandMBS.kOptionPreFetchRows = "PreFetchRows"
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the option constants.
Example:
dim cmd as new SQLCommandMBS
// do something

dim nBulkSize as Integer = 1000
cmd.Option(SQLCommandMBS.kOptionPreFetchRows) = str(nBulkSize)

Feedback, Comments & Corrections

SQLCommandMBS.kParamDirTypeInput = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the parameter direction type constants.
Notes: Input parameter.

Feedback, Comments & Corrections

SQLCommandMBS.kParamDirTypeInputOutput = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the parameter direction type constants.
Notes: Input/output parameter.

Feedback, Comments & Corrections

SQLCommandMBS.kParamDirTypeOutput = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the parameter direction type constants.
Notes: Output parameter.

Feedback, Comments & Corrections

SQLCommandMBS.kParamDirTypeReturn = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
Function: One of the parameter direction type constants.
Notes: Returning parameter.

Feedback, Comments & Corrections

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




Links
MBS Xojo PDF Plugins