MBS Xojo Developer Conference and Training
Join us from 11th to 14th September 2013 in Koblenz.
Join us from 11th to 14th September 2013 in Koblenz.
Platforms to show: All Mac Windows Linux Cross-Platform
SQLite3MBS class
Super class: SQLAPIMBS
class, SQL,
MBS Real Studio SQL Plugin
(SQL),
class SQLite3MBS,
Plugin version: 9.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: Yes, Feedback.
Function: The class for the native SQLite API.
Example:
Notes:
Subclass of the SQLAPIMBS class.
Plugin version: 9.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: Yes, Feedback.
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
- 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 ErrCode(Conn as SQLConnectionMBS) as integer
- method ErrMessage(Conn as SQLConnectionMBS) as string
- method LastInsertRowID(Conn as SQLConnectionMBS) as Int64
- 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
- method Version as string
- method VersionNumber as integer
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
- property Connection as SQLConnectionMBS
This class has no sub classes.
Some examples which use this class:
The items on this page are in the following plugins: MBS Real Studio SQL Plugin.
Links
MBS Xojo Plugins