Platforms to show: All Mac Windows Linux Cross-Platform

SQLite3MBS class   Deprecated

Super class: SQLAPIMBS

Var con as new SQLConnectionMBS
Var path as string = "/tmp/test.db" // change path for Windows!

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

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

• 5 properties
  • property ConnectionHandle as Ptr
  • property MemoryHighwater as Int64
  • property MemoryUsed as Int64
  • Property Version as string
  • Property VersionNumber as Integer
• 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

Error Codes

Super class SQLAPIMBS

• 2 properties
  • property ClassName as String
  • property Connection as Variant

This class has no sub classes.

Blog Entries

• News from the MBS Xojo Plugins Version 22.2
• MBS Xojo Plugins, version 22.2pr1
• MBS Xojo Plugins, version 19.5pr1
• MonkeyBread Software Releases the MBS Xojo Plugins in version 17.4
• 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
• Embedded SQLite and encryption
• [ANN] MonkeyBread Software Releases the MBS Xojo / Real Studio plug-ins in version 14.4
• SQLite Backup Functions
• MBS REALbasic plug-ins version 9.5

Videos

• Presentation from London conference about MBS Plugins.

Release notes

• Version 22.2
  • Added ConnectionHandle property to SQLite3MBS class.
• Version 19.5
  • Changed BackupInit in SQLite3MBS and SQLiteBackupInit in SQLConnectionMBS and SQLDatabaseMBS classes to take variant and accept both database and connection object for dest and source.
  • Changed MemoryHighwater and MemoryUsed in SQLite3MBS class to be regular properties.
  • Removed Connection parameters for SQLAPIMBS methods. Not needed anymore for MySQLMBS, DB2MBS, PostgreSQLAPIMBS and SQLite3MBS.
  • Removed LibraryLoaded properties from DB2MBS, InformixMBS, MySQLMBS, PostgreSQLAPIMBS and SQLite3MBS classes.
• Version 17.4
  • Added MemoryUsed and MemoryHighwater properties to SQLite3MBS class.
• Version 17.1
  • Added LibraryLoaded property to DB2MBS, InformixMBS, MySQLMBS, PostgreSQLAPIMBS and SQLite3MBS.

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

SQLite3BackupMBS   -   SQLiteFunctionMBS