Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLDatabaseMBS class.

SQLDatabaseMBS.kOptionLibraryCubeSQL = "CUBESQL.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 19.3
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

Tells the plugin where to find the library for CubeSQL. Only needed if you don't use InternalCubeSQLLibraryMBS module!

The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the CubeSQL download on their homepage.

If no value is given, we default to
Windows: cubeSQL_64bit.dll;cubesql.dll
macOS: libcubesql_r.dylib
Linux: libcubesql_r.so

The default is set to work in most cases and try various possible library names.

SQLDatabaseMBS.kOptionLibraryDuckDB = "DUCKDB.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 21.2
ConstantsGroup: Options to specify the library with SetFileOption
Example
One of the option constant to specify the library with the SetFileOption method.

dim con as SQLDatabaseMBS // your connection

dim f as FolderItem = GetFolderItem("duckdb.dll")
con.SetFileOption con.kOptionLibraryDuckDB, f

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.

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


The biggest plugin in space...