Platforms to show: All Mac Windows Linux Cross-Platform

SQLite3MBS class   Deprecated

Super class: SQLAPIMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
class SQL MBS SQL Plugin 9.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
The class for the native SQLite API.
Example
dim con as new SQLConnectionMBS
dim path as string = "/tmp/test.db" // change path for Windows!

con.Connect(path,"","",SQLConnectionMBS.kSQLiteClient)

dim api as SQLAPIMBS = con.NativeAPI
if api isa SQLite3MBS then
dim s as SQLite3MBS = SQLite3MBS(api)
MsgBox s.Version
end if

Deprecated in favor of direct methods on SQLConnectionMBS. Please let us know if you need more SQLite specific functions.
Subclass of the SQLAPIMBS class.

Error Codes

Constant Value Description
kErrorAbort 4 Callback routine requested an abort.
kErrorAuth 23 Authorization denied
kErrorBusy 5 The database file is locked.
kErrorCantopen 14 Unable to open the database file.
kErrorConstraint 19 Abort due to constraint violation.
kErrorCorrupt 11 The database disk image is malformed.
kErrorDone 101 sqlite3_step() has finished executing.
kErrorEmpty 16 Database is empty
kErrorError 1 SQL error or missing database.
kErrorFormat 24 Auxiliary database format error.
kErrorFull 13 Insertion failed because database is full.
kErrorInternal 2 Internal logic error in SQLite
kErrorInterrupt 9 Operation terminated by sqlite3_interrupt().
kErrorIoerr 10 Some kind of disk I/O error occurred.
kErrorLocked 6 A table in the database is locked.
kErrorMismatch 20 Data type mismatch.
kErrorMisuse 21 Library used incorrectly.
kErrorNolfs 22 Uses OS features not supported on host.
kErrorNoMem 7 Out of memory.
kErrorNotaDB 26 File opened that is not a database file.
kErrorNotFound 12 NOT USED. Table or record not found.
kErrorOk 0 Successful result
kErrorPerm 3 Access permission denied.
kErrorProtocol 15 NOT USED. Database lock protocol error.
kErrorRange 25 2nd parameter to sqlite3_bind out of range.
kErrorReadonly 8 Attempt to write a readonly database.
kErrorRow 100 sqlite3_step() has another row ready.
kErrorSchema 17 The database schema changed.
kErrorToobig 18 String or BLOB exceeds size limit.

Super class SQLAPIMBS

This class has no sub classes.

Blog Entries

Videos

Release notes


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


SQLite3BackupMBS   -   SQLiteFunctionMBS


The biggest plugin in space...