Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

SQLite3MBS class

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
Function: 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
Notes: Subclass of the SQLAPIMBS class.

Feedback, Comments & Corrections

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.

Some examples which use this class:


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


SQLite3BackupMBS   -   SQLLongBinaryMBS




Links
MBS FileMaker tutorial videos