Platforms to show: All Mac Windows Linux Cross-Platform

Next items

SQLDatabaseMBS.kANSILevel0 = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the ANSI level constants.
Notes: ANSI Level 0
SQLDatabaseMBS.kANSILevel1 = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the ANSI level constants.
Notes: ANSI Level 1
SQLDatabaseMBS.kANSILevel2 = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the ANSI level constants.
Notes: ANSI Level 2
SQLDatabaseMBS.kANSILevel3 = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the ANSI level constants.
Notes: ANSI Level 3
SQLDatabaseMBS.kAutoCommitOff = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the constants for the autocommit property.
Example:
dim db as SQLDatabaseMBS // your database connection

db.AutoCommit = SQLDatabaseMBS.kAutoCommitOn
Notes: Autocommit is off.
SQLDatabaseMBS.kAutoCommitOn = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the constants for the autocommit property.
Example:
dim db as SQLDatabaseMBS // your database connection

db.AutoCommit = SQLDatabaseMBS.kAutoCommitOn
Notes: Autocommit is on.
SQLDatabaseMBS.kAutoCommitUnknown = -1
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the constants for the autocommit property.
Notes: Autocommit unknown
SQLDatabaseMBS.kCommandTypeSQLStatement = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 14.1
Function: One of the constants for the command type.
Notes: Command is an SQL statement.
SQLDatabaseMBS.kCommandTypeSQLStatementRaw = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 14.1
Function: One of the constants for the command type.
Notes: Command is an SQL statement that mustn't be interpreted by SQLAPI.
SQLDatabaseMBS.kCommandTypeStoredProcedure = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 14.1
Function: One of the constants for the command type.
Notes: Command is a stored procedure or a function.
SQLDatabaseMBS.kCommandTypeUnknown = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 14.1
Function: One of the constants for the command type.
Notes: Used by default. Library detects command type automatically.
SQLDatabaseMBS.kErrorBindVarNotFound = 7
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Bind variable not found.
SQLDatabaseMBS.kErrorClientInitFails = 6
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Initialization failed for client.
SQLDatabaseMBS.kErrorClientNotSet = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Client not set.
SQLDatabaseMBS.kErrorClientNotSupported = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Unsupported client type for this platform.
SQLDatabaseMBS.kErrorClientVersionOld = 5
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Library file is too old.
SQLDatabaseMBS.kErrorFieldNotFound = 8
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Field not found.
SQLDatabaseMBS.kErrorGetLibraryVersionFails = 4
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Failed to query library version.
SQLDatabaseMBS.kErrorLoadLibraryFails = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Failed to load a library. For example path could be wrong or 32/64bit mismatch.
SQLDatabaseMBS.kErrorNoMemory = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Out of memory.
SQLDatabaseMBS.kErrorUnknownColumnType = 11
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Unknown column type.
SQLDatabaseMBS.kErrorUnknownDataType = 9
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Unknown data type.
SQLDatabaseMBS.kErrorUnknownParameterType = 10
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Unknown parameter type.
SQLDatabaseMBS.kErrorWrongConversion = 12
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Failed to convert a value, e.g. string to number.
SQLDatabaseMBS.kErrorWrongDatetime = 13
Type Topic Plugin Version
const SQL MBS SQL Plugin 16.0
Function: One of the SQL Plugin error codes.
Notes: Can't convert text to date.
SQLDatabaseMBS.kLevelUnknown = -1
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the isolation level constants.
Notes: Unknown
SQLDatabaseMBS.kOptionLibraryCubeSQL = "CUBESQL.LIBS"
Type Topic Plugin Version
const SQL MBS SQL Plugin 19.3
Function: One of the option constant to specify the library with the SetFileOption method.
Example:
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("cubesql.dll")
con.SetFileOption con.kOptionLibraryCubeSQL, f
Notes: for CubeSQL.
SQLDatabaseMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for DB2.
SQLDatabaseMBS.kOptionLibraryFirebird = "IBASE.LIBS"
Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Firebird.

Next items

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

Feedback: Report problem or ask question.

The biggest plugin in space...


Start Chat