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)
Deprecated in favor of direct methods on SQLConnectionMBS. Please let us know if you need more SQLite specific functions.
Subclass of the SQLAPIMBS class.
- 4 properties
- 18 methods
- method BackupFinish(Backup as SQLite3BackupMBS) as Integer
- method BackupInit(Dest as Variant, DestName as String, Source as Variant, 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(OnOff as boolean)
- method ErrCode as Integer
- method ErrMessage as string
- method LastInsertRowID as Int64
- method LoadExtension(file as FolderItem, ByRef ErrorMessage as String) as Integer
- method LoadExtension(path as String, ByRef ErrorMessage as String) as Integer
- method MemoryHighwater(reset as boolean) as Int64
- method ReKey(Key as String) as Integer
- method SetBusyHandler(MaxAttempts as Integer = 5)
- method SetBusyTimeout(TimeOutMS as Integer = 20)
- method SetKey(Key as String) as Integer
- method TableColumnMetaData(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
- 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.
- MonkeyBread Software Releases the MBS Xojo Plugins in version 17.4
- MBS Xojo Plugins, version 17.4pr2
- MBS Xojo / Real Studio Plugins, version 17.1pr1
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 16.4
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 16.1
- MBS Xojo / Real Studio Plugins, version 16.1pr3
- [ANN] MonkeyBread Software Releases the MBS Xojo / Real Studio plug-ins in version 14.4
- MBS Xojo / Real Studio Plugins, version 14.4pr9
- SQLite Backup Functions
- MBS REALbasic plug-ins version 9.5
The items on this page are in the following plugins: MBS SQL Plugin.
MBS Xojo tutorial videos