Monkeybread Xojo plugin - SQLDatabaseMBS constants

Platforms to show: All Mac Windows Linux Cross-Platform

SQLDatabaseMBS.kOptionLibraryInformix = "INFCLI.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Informix.

SQLDatabaseMBS.kOptionLibraryInterbase = "IBASE.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Interbase.

SQLDatabaseMBS.kOptionLibraryMySQL = "MYSQL.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for MySQL. Library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the MySQL download on their homepage.

SQLDatabaseMBS.kOptionLibraryODBC = "ODBC.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for ODBC.

SQLDatabaseMBS.kOptionLibraryOracle = "OCI8.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Oracle.

SQLDatabaseMBS.kOptionLibraryPostgreSQL = "LIBPQ.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Postgre SQL.

SQLDatabaseMBS.kOptionLibrarySQLanywhere = "SQLANY.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	15.2

One of the option constant to specify the library with the SetFileOption method.

for SQL Anywhere.

SQLDatabaseMBS.kOptionLibrarySQLBase = "SQLBASE.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for SQLbase.

SQLDatabaseMBS.kOptionLibrarySQLite = "SQLITE.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

Example

dim con as SQLDatabaseMBS // your database connection

dim f as FolderItem = GetFolderItem("sqlite.dylib")
con.SetFileOption con.kOptionLibrarySQLite, f

for SQLite. Can also be the spatialite or SQLcipher library.

SQLDatabaseMBS.kOptionLibrarySybaseComn = "SYBCOMN.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

OOne of the option constant to specify the library with the SetFileOption method.

for Sybase.

SQLDatabaseMBS.kOptionLibrarySybaseCS = "SYBCS.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Sybase.

SQLDatabaseMBS.kOptionLibrarySybaseCT = "SYBCT.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Sybase.

SQLDatabaseMBS.kOptionLibrarySybaseIntl = "SYBINTL.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Sybase.

SQLDatabaseMBS.kOptionLibrarySybaseTCL = "SYBTCL.LIBS"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the option constant to specify the library with the SetFileOption method.

for Sybase.

SQLDatabaseMBS.kReadCommitted = 1

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the isolation level constants.

Read committed.

SQLDatabaseMBS.kReadUncommitted = 0

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the isolation level constants.

Read uncommitted.

SQLDatabaseMBS.kRepeatableRead = 2

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the isolation level constants.

Repeatable read.

SQLDatabaseMBS.kSerializable = 3

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	12.3

One of the isolation level constants.

Serializable.

SQLDatabaseMBS.kSnapshot = 4

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	21.2

One of the isolation level constants.

Changes made in other transactions can not be seen. For Microsoft SQL Server.

SQLDatabaseMBS.SQLiteInMemory = "Sqlite::memory:"

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	19.2

Connection string for SQLite for a new in-memory database.

Prefixed with SQLite to use directly.

Previous items

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

💬 Ask a question or report a problem