Platforms to show: All Mac Windows Linux Cross-Platform
The plugin part MBS SQL Plugin:SQLDatabase:
All Console safe, 112 entry points.
- class Database
- method Close
- method SQLSelect(SelectString as string) as RecordSet
- method SQLExecute(ExecuteString as string)
- method Connect as boolean
- method Commit
- method Rollback
- method Prepare(statement as String) as PreparedSQLStatement
- method InsertRecord(TableName as String, Data as DatabaseRecord)
- method AddRow(TableName as String, row as DatabaseRow)
- method BeginTransaction
- method CommitTransaction
- method Connect
- method RollbackTransaction
- method ExecuteSQL(sql As String, ParamArray values As Variant)
- method ExecuteSQL(sql As String, values() As Variant)
- method SelectSQL(sql As String, ParamArray values As Variant) as RowSet
- method SelectSQL(sql As String, values() As Variant) as RowSet
- property DatabaseName as String
- property ErrorMessage as String
- property UserName as String
- property Host as String
- property Password as String
- property ErrorCode as Integer
- property Error as Boolean
- class SQLDatabaseMBS
- method SQLiteConnectionHandle as Ptr
- method SQLiteLibVersion as String
- method SQLiteMemoryHighwater(reset as boolean = false) as Int64
- method SQLiteSetBusyTimeout(TimeOutMS as Integer = 20)
- method SQLiteSetBusyHandler(MaxAttempts as Integer = 5)
- method SQLiteThreadsafe as integer
- method SQLiteEnableLoadExtension(OnOff as boolean)
- method SQLiteReKey(Key as String) as Integer
- method SQLiteSetKey(Key as String) as Integer
- method SQLiteLoadExtension(path as String, ByRef ErrorMessage as String) as Integer
- method SQLiteLoadExtension(file as FolderItem, ByRef ErrorMessage as String) as Integer
- method SQLiteTableColumnMetaData(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 SQLiteBackupPageCount(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupRemaining(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupFinish(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupStep(Backup as SQLite3BackupMBS, Pages as Integer) as integer
- method SQLiteBackupInit(Dest as Variant, DestName as String, Source as Variant, SourceName as String) as SQLite3BackupMBS
- method SQLiteLastInsertRowID as Int64
- method SQLiteMemoryUsed as Int64
- method MySQLInsertID as Int64
- method CubeSQLSendData(data as String)
- method CubeSQLSendData(data as MemoryBlock)
- method CubeSQLSendEndData
- method CubeSQLReceiveData(byref data as String, byref IsEndChunk as Boolean) as Boolean
- method CubeSQLLastInsertID as Int64
- method CancelAllCommands
- method Commands as SQLCommandMBS()
- method UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)
- method InsertRecord(TableName as String, Record as Dictionary)
- method Listen
- method BeginTransaction
- method Constructor(globals as SQLGlobalsMBS = nil)
- method SQLSelectMT(SelectString as string, CommandType as integer = 0) as RecordSet
- method SQLExecuteMT(ExecuteString as string, CommandType as integer = 0)
- method SQLSelect(SelectString as string, CommandType as integer) as RecordSet
- method SQLExecute(ExecuteString as string, CommandType as integer)
- method SetFileOption(name as string, file as folderitem)
- method ConnectMT as Boolean
- method Connect as boolean
- method Prepare(statement as string) as SQLPreparedStatementMBS
- property Option(name as string) as string
- property Tag as Variant
- property ServerVersionString as String
- property isConnected as Boolean
- property isAlive as Boolean
- property ServerVersion as Integer
- property ClientVersion as Integer
- property AutoCommit as Integer
- property IsolationLevel as Integer
- property Connection as SQLConnectionMBS
- property RaiseExceptions as Boolean
- property Client as Integer
- property Scrollable as Boolean
- property LastStatement as String
- property SQLiteEncryptionKey as String
- property NativeAPI as Variant
- property Options as Dictionary
- property RowsAffected as Integer
- event Trace(traceInfo as integer, SQL as string, Command as SQLCommandMBS)
- event WillConnect
- event DidConnect
- event PostgresNotification(NotificationName as string, PID as Integer, Extras as String)
- class SQLPreparedStatementMBS
- method Bind(Values as Dictionary)
- method SQLSelectMT(ParamArray bindItems As Variant) As RecordSet
- method SQLExecuteMT(ParamArray bindItems As Variant)
- method Bind(name As String, value As Variant, type as integer)
- method Bind(name As String, value As Variant)
- method BindType(name As String, type As Integer)
- method Bind(zeroBasedIndex As Integer, value As Variant, type as integer)
- method Bind(zeroBasedIndex As Integer, value As Variant)
- method Bind(values() As Variant)
- method BindType(zeroBasedIndex As Integer, type As Integer)
- method BindType(types() As Integer)
- method SQLSelect(ParamArray bindItems As Variant) As RecordSet
- method SQLExecute(ParamArray bindItems As Variant)
- method Constructor
- method Clear
- method ExecuteSQL(ParamArray bindItems As Variant)
- method SelectSQL(ParamArray bindItems As Variant) As Rowset
- method ExecuteSQLMT(ParamArray bindItems As Variant)
- method SelectSQLMT(ParamArray bindItems As Variant) As Rowset
- property SQL as String
- property Scrollable as Boolean
- property BoundTypes as Dictionary
- property BoundValues as Dictionary
Blog Entries
- MonkeyBread Software Releases the MBS Xojo Plugins in version 22.2
- News from the MBS Xojo Plugins Version 21.1
- MBS Xojo Plugins 18.3
- New SQL Insert and Update functions for our Xojo Plugin
- Crossplatform connection to Microsoft SQL Server in Xojo
- Microsoft SQL Server connectivity
- Prefetching records from databases
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 16.1
- [ANN] MonkeyBread Software Releases the MBS Xojo / Real Studio plug-ins in version 14.3
- MBS Xojo Web Starter Kit in version 1.1
Videos
Xojo Developer Magazine
- 21.1, page 9: News
- 18.5, page 9: News
- 14.1, pages 24 to 30: The MBS SQL Plugin, An alternative way to connect to databases by Christian Schmitz
- 13.4, page 11: News
- 12.4, page 9: News
- 11.3, page 41: Welcome to Xojo, Real Studio gets a new identity by Marc Zeedar
- 11.3, page 11: News
- 11.2, page 8: News
- 11.2, page 33: Windows Installing, Using Inno Setup to Create a Windows Installer App by Marc Zeedar
- 11.1, page 9: News