Super class: SQLAPIMBS
|Type||Topic||Plugin||Version||macOS||Windows||Linux||Console & Web||iOS|
|class||SQL||MBS SQL Plugin||9.5||Yes||Yes||Yes||Yes||No|
dim con as new SQLConnectionMBS
dim path as string = "/tmp/test.db" // change path for Windows!
dim api as SQLAPIMBS = con.NativeAPI
if api isa SQLite3MBS then
dim s as SQLite3MBS = SQLite3MBS(api)
- 2 properties
- 3 shared properties
- 17 methods
- method BackupFinish(Backup as SQLite3BackupMBS) as Integer
- method BackupInit(Dest as SQLConnectionMBS, DestName as String, Source as SQLConnectionMBS, SourceName as String) as SQLite3BackupMBS
- method BackupPageCount(Backup as SQLite3BackupMBS) as Integer
- method BackupRemaining(Backup as SQLite3BackupMBS) as Integer
- method BackupStep(Backup as SQLite3BackupMBS, Pages as Integer) as Integer
- method EnableLoadExtension(Conn as SQLConnectionMBS, OnOff as boolean)
- method ErrCode(Conn as SQLConnectionMBS) as Integer
- method ErrMessage(Conn as SQLConnectionMBS) as string
- method LastInsertRowID(Conn as SQLConnectionMBS) as Int64
- method LoadExtension(Conn as SQLConnectionMBS, file as FolderItem, ByRef ErrorMessage as String) as Integer
- method LoadExtension(Conn as SQLConnectionMBS, path as String, ByRef ErrorMessage as String) as Integer
- method ReKey(Conn as SQLConnectionMBS, Key as String) as Integer
- method SetBusyHandler(Conn as SQLConnectionMBS, MaxAttempts as Integer = 5)
- method SetBusyTimeout(Conn as SQLConnectionMBS, TimeOutMS as Integer = 20)
- method SetKey(Conn as SQLConnectionMBS, Key as String) as Integer
- method TableColumnMetaData(Conn as SQLConnectionMBS, DBName as string, TableName as string, ColumnName as string, byref DataType as string, byref CollationSequence as string, byref NotNull as boolean, byref PrimaryKey as boolean, byref AutoIncrement as Boolean) as Integer
- method Threadsafe as Integer
- shared method MemoryHighwater(reset as boolean) as Int64
- 29 constants
Callback routine requested an abort.
The database file is locked.
Unable to open the database file.
Abort due to constraint violation.
The database disk image is malformed.
sqlite3_step() has finished executing.
Database is empty
SQL error or missing database.
Auxiliary database format error.
Insertion failed because database is full.
Internal logic error in SQLite
Operation terminated by sqlite3_interrupt().
Some kind of disk I/O error occurred.
A table in the database is locked.
Data type mismatch.
Library used incorrectly.
Uses OS features not supported on host.
Out of memory.
File opened that is not a database file.
NOT USED. Table or record not found.
Access permission denied.
NOT USED. Database lock protocol error.
2nd parameter to sqlite3_bind out of range.
Attempt to write a readonly database.
sqlite3_step() has another row ready.
The database schema changed.
String or BLOB exceeds size limit.
Super class SQLAPIMBS
This class has no sub classes.
Some examples which use this class:
- /SQL/SQLDatabaseMBS SQLite load extension
- /SQL/SQLite Backup
- /SQL/SQLite load extension
- /SQL/SQLite Lock Test/SQLite Busy Handler
- /SQL/SQLite Table Definition
- /SQL/SQLite Version
- /SQL/SQLite Version with sqlcipher
The items on this page are in the following plugins: MBS SQL Plugin.
MBS FileMaker tutorial videos