Monkeybread Xojo plugin - SQLDatabaseMBS constants

Platforms to show: All Mac Windows Linux Cross-Platform

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.