SQL
Online Documentation - Statistics - FAQ - Plugin Parts (All, Dependencies) - Class hierarchy
New in Version
22.2
22.3
22.4
22.5
23.0
23.1
23.2
23.3
23.4
23.5
24.0
24.1
The list of the topics,
classes,
interfaces,
controls,
modules,
global methods by category,
global methods by name,
screenshots,
licenses
and examples.
Platforms to show: All Mac Windows Linux Cross-Platform
SQL
Access to SQL databases (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL and ODBC, SQLite).
- Globals
- Classes
- class Database
- class SQLBLobMBS
- class SQLBytesMBS
- class SQLCLobMBS
- class SQLCommandMBS
- method AsRecordSet as RecordSet
- method AsRowSet as RowSet
- method Cache
- method Cancel
- method Close
- method Constructor
- method Constructor(connection as SQLConnectionMBS, SQLCommand as String, CommandType as Integer = 0)
- method CreateParam(name as string, ParamType as Integer, DirType as Integer=0) as SQLParamMBS
- method CreateParam(name as string, ParamType as Integer, NativeType as Integer, ParamSize as Integer, ParamPrecision as Integer, ParamScale as Integer, DirType as Integer=0) as SQLParamMBS
- method DB2SQLExecDirect(sql as string)
- method DB2SQLRowCount as Int64
- method DestroyParams
- method Execute
- method ExecuteCommand(SQLCommand as string, CommandType as Integer=0)
- method ExecuteCommandMT(SQLCommand as string, CommandType as Integer=0)
- method ExecuteMT
- method FetchFirst as boolean
- method FetchLast as boolean
- method FetchNext as boolean
- method FetchPos(offset as Integer, relative as boolean = false) as boolean
- method FetchPrior as boolean
- method Field(index as Integer) as SQLFieldMBS
- method Field(name as string) as SQLFieldMBS
- method FieldExists(name as string) as Boolean
- method FieldNames as String()
- method Open
- method Param(ID as Integer) as SQLParamMBS
- method Param(name as string) as SQLParamMBS
- method ParamByIndex(index as Integer) as SQLParamMBS
- method PostgreSQLField(RecordIndex as integer, FieldIndex as integer) as string
- method PostgreSQLField(RecordIndex as integer, FieldName as string) as string
- method PostgreSQLFieldCount as Integer
- method PostgreSQLRowCount as Integer
- method Prepare
- method setCommandText(SQLCommand as string, CommandType as Integer = 0)
- method SetParameters(Params as dictionary)
- method Value(index as Integer) as SQLValueReadMBS
- method Value(name as string) as SQLValueReadMBS
- shared property CommandCount as Integer
- property CommandText as string
- property CommandType as Integer
- property Connection as SQLConnectionMBS
- property FieldCount as Integer
- property Fields as Dictionary
- property hasCache as Boolean
- property isBOF as Boolean
- property isEOF as Boolean
- property isExecuted as boolean
- property isExecuting as Boolean
- property isOpened as boolean
- property isResultSet as boolean
- property Options as Dictionary
- property ParamCount as Integer
- property Parameters as Dictionary
- property RowsAffected as Integer
- property Tag as Variant
- property Option(name as string) as string
- event Trace(traceInfo as Integer, SQL as string)
- event Working
- class SQLConnectionMBS
- method BeginTransaction
- method CancelAllCommands
- method Commands as SQLCommandMBS()
- method Commit
- method Connect(DBString as string, UserID as string, Password as string, client as Integer = 0)
- method ConnectMT(DBString as string, UserID as string, Password as string, client as Integer = 0)
- method CubeSQLLastInsertID as Int64
- method CubeSQLReceiveData(byref data as String, byref IsEndChunk as Boolean) as Boolean
- method CubeSQLSendData(data as MemoryBlock)
- method CubeSQLSendData(data as String)
- method CubeSQLSendEndData
- method Disconnect
- method InsertRecord(TableName as String, Record as Dictionary)
- shared method kOptionLibrarySeparator as String
- method Listen
- method MySQLInsertID as Int64
- method Rollback
- method SetFileOption(name as string, file as folderitem)
- method SQLExecute(command as string, CommandType as Integer = 0)
- method SQLExecuteMT(command as string, CommandType as Integer = 0)
- method SQLiteBackupFinish(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupInit(Dest as Variant, DestName as String, Source as Variant, SourceName as String) as SQLite3BackupMBS
- method SQLiteBackupPageCount(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupRemaining(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupStep(Backup as SQLite3BackupMBS, Pages as Integer) as integer
- method SQLiteConnectionHandle as Ptr
- method SQLiteEnableLoadExtension(OnOff as boolean)
- method SQLiteLastInsertRowID as Int64
- method SQLiteLibVersion as String
- method SQLiteLoadExtension(file as FolderItem, ByRef ErrorMessage as String) as Integer
- method SQLiteLoadExtension(path as String, ByRef ErrorMessage as String) as Integer
- method SQLiteMemoryHighwater(reset as boolean = false) as Int64
- method SQLiteMemoryUsed as Int64
- method SQLiteReKey(Key as String) as Integer
- method SQLiteSetBusyHandler(MaxAttempts as Integer = 5)
- method SQLiteSetBusyTimeout(TimeOutMS as Integer = 20)
- method SQLiteSetKey(Key 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 SQLiteThreadsafe as integer
- method SQLSelect(command as string, CommandType as Integer = 0) as string
- method SQLSelectAsRecordSet(command as string, CommandType as Integer = 0) as RecordSet
- method SQLSelectAsRecordSetMT(command as string, CommandType as Integer = 0) as RecordSet
- method SQLSelectAsRowSet(command as string, CommandType as integer = 0) as RowSet
- method SQLSelectAsRowSetMT(command as string, CommandType as integer = 0) as RowSet
- method SQLSelectMT(command as string, CommandType as Integer = 0) as string
- method UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)
- Property AutoCommit as Integer
- Property Client as Integer
- Property ClientVersion as Integer
- shared property ConnectionCount as Integer
- Property Error as Boolean
- Property ErrorCode as Integer
- Property ErrorMessage as string
- Property isAlive as boolean
- Property isConnected as boolean
- Property IsolationLevel as Integer
- property LastStatement as String
- property Options as Dictionary
- property RaiseExceptions as Boolean
- property RowsAffected as Integer
- property Scrollable as Boolean
- Property ServerVersion as Integer
- Property ServerVersionString as string
- property SQLiteEncryptionKey as String
- property Tag as Variant
- shared property VariantsKeepSQLObjects as Boolean
- property Option(name as string) as string
- event DidConnect
- event PostgresNotification(NotificationName as string, PID as Integer, Extras as String)
- event Trace(traceInfo as Integer, SQL as string, Command as SQLCommandMBS)
- event WillConnect
- event Working
- class SQLDatabaseMBS
- method BeginTransaction
- method CancelAllCommands
- method Commands as SQLCommandMBS()
- method Connect as boolean
- method ConnectMT as Boolean
- method Constructor(globals as SQLGlobalsMBS = nil)
- method CubeSQLLastInsertID as Int64
- method CubeSQLReceiveData(byref data as String, byref IsEndChunk as Boolean) as Boolean
- method CubeSQLSendData(data as MemoryBlock)
- method CubeSQLSendData(data as String)
- method CubeSQLSendEndData
- method InsertRecord(TableName as String, Record as Dictionary)
- method Listen
- method MySQLInsertID as Int64
- method Prepare(statement as string) as SQLPreparedStatementMBS
- method SetFileOption(name as string, file as folderitem)
- method SQLExecute(ExecuteString as string, CommandType as Integer)
- method SQLExecuteMT(ExecuteString as string, CommandType as Integer = 0)
- method SQLiteBackupFinish(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupInit(Dest as Variant, DestName as String, Source as Variant, SourceName as String) as SQLite3BackupMBS
- method SQLiteBackupPageCount(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupRemaining(Backup as SQLite3BackupMBS) as integer
- method SQLiteBackupStep(Backup as SQLite3BackupMBS, Pages as Integer) as integer
- method SQLiteConnectionHandle as Ptr
- method SQLiteEnableLoadExtension(OnOff as boolean)
- method SQLiteLastInsertRowID as Int64
- method SQLiteLibVersion as String
- method SQLiteLoadExtension(file as FolderItem, ByRef ErrorMessage as String) as Integer
- method SQLiteLoadExtension(path as String, ByRef ErrorMessage as String) as Integer
- method SQLiteMemoryHighwater(reset as boolean = false) as Int64
- method SQLiteMemoryUsed as Int64
- method SQLiteReKey(Key as String) as Integer
- method SQLiteSetBusyHandler(MaxAttempts as Integer = 5)
- method SQLiteSetBusyTimeout(TimeOutMS as Integer = 20)
- method SQLiteSetKey(Key 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 SQLiteThreadsafe as integer
- method SQLSelect(SelectString as string, CommandType as Integer) as RecordSet
- method SQLSelectMT(SelectString as string, CommandType as Integer = 0) as RecordSet
- method UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)
- property AutoCommit as Integer
- property Client as Integer
- property ClientVersion as Integer
- Property Connection as SQLConnectionMBS
- property isAlive as boolean
- property isConnected as boolean
- property IsolationLevel as Integer
- property LastStatement as String
- property Options as Dictionary
- property RaiseExceptions as Boolean
- property RowsAffected as Integer
- property Scrollable as Boolean
- property ServerVersion as Integer
- property ServerVersionString as string
- property SQLiteEncryptionKey as String
- property Tag as Variant
- property Option(name as string) as string
- event DidConnect
- event PostgresNotification(NotificationName as string, PID as Integer, Extras as String)
- event Trace(traceInfo as Integer, SQL as string, Command as SQLCommandMBS)
- event WillConnect
- class SQLDataConsumerMBS
- event Write(PieceType as Integer, data as string, Length as UInt32, BlobSize as UInt32)
- class SQLDataProviderMBS
- event Read(byref PieceType as Integer, Length as UInt32) as string
- class SQLDateTimeMBS
- method Constructor(DateTimeValue as DateTime)
- method Constructor(DateValue as Date)
- method Constructor(Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0)
- method Constructor(other as SQLDateTimeMBS)
- method Constructor(StringValue as String)
- method Constructor(value as Double)
- method Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer = 0, Fraction as Integer = 0, TimeZone as String = "")
- method Constructor(Year as Integer, Month as Integer, Day as Integer, Hour as Integer, Minute as Integer, Second as Integer, TimeZone as String)
- method Set(DateTimeValue as DateTime)
- method Set(value as Date)
- property DateTimeValue as DateTime
- property DateValue as Date
- property Day as Integer
- property DayOfWeek as Integer
- property DayOfYear as Integer
- property DoubleValue as Double
- property Fraction as Integer
- property hasDate as Boolean
- property hasTime as Boolean
- property Hour as Integer
- property Minute as Integer
- property Month as Integer
- property Second as Integer
- Property StringValue as string
- property TimeZone as String
- property Year as Integer
- class SQLErrorExceptionMBS
- class SQLFieldMBS
- class SQLGlobalsMBS
- class SQLIntervalMBS
- class SQLite3BackupMBS
- class SQLiteFunctionMBS
- class SQLLongBinaryMBS
- class SQLLongCharMBS
- class SQLLongOrLobMBS
- class SQLNotInitializedExceptionMBS
- class SQLNullMBS
- class SQLNumericMBS
- class SQLParamMBS
- class SQLPositionMBS
- class SQLPreparedStatementMBS
- method Bind(name As String, value as Variant)
- method Bind(name As String, value as Variant, type as Integer)
- method Bind(Values as Dictionary)
- method Bind(values() as Variant)
- method Bind(zeroBasedIndex as Integer, value as Variant)
- method Bind(zeroBasedIndex as Integer, value as Variant, type as Integer)
- method BindType(name As String, type as Integer)
- method BindType(types() as Integer)
- method BindType(zeroBasedIndex as Integer, type as Integer)
- method Clear
- method Constructor
- method ExecuteSQL(ParamArray bindItems As Variant)
- method ExecuteSQLMT(ParamArray bindItems As Variant)
- method SelectSQL(ParamArray bindItems As Variant) As RowSet
- method SelectSQLMT(ParamArray bindItems As Variant) As Rowset
- method SQLExecute(ParamArray bindItems as Variant)
- method SQLExecuteMT(ParamArray bindItems as Variant)
- method SQLSelect(ParamArray bindItems as Variant) As RecordSet
- method SQLSelectMT(ParamArray bindItems as Variant) As RecordSet
- property BoundTypes as Dictionary
- property BoundValues as Dictionary
- property Scrollable as Boolean
- property SQL as String
- class SQLStringMBS
- class SQLUnsupportedExceptionMBS
- class SQLValueMBS
- class SQLValueReadMBS
- Class Extensions
- Modules
- module InternalCubeSQLLibraryMBS
- module InternalSQLiteLibraryMBS
- method CompileOption(index as Integer) as String
- method CompileOptionUsed(optionName as String) as Boolean
- method DumpToFile(SqliteDBConectionHandle as Ptr, File as FolderItem, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)
- method DumpToString(SqliteDBConectionHandle as Ptr, byref Data as String, MaximumSize as Integer = 10000000, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)
- method isKeyword(name as string) as boolean
- method Keywords as String()
- method LoadICU as Boolean
- method SourceID as String
- method Use as boolean
- method Version as String
- method VersionNumber as Integer
- property ICUEnabled as Boolean
- property ICULoaded as Boolean
- property ICUUsed as Boolean
- property MemoryHighwater as Int64
- property MemoryUsed as Int64
- property Path as String
Release notes
- Version 24.1
- Version 24.0
- Added checks for SQLDatabaseMBS class to raise an exception if you try to close, SQLExecute or SQLSelect while a background thread runs a SQL query.
- Added CopyMemoryBlock method to SQLStringMBS class.
- Added isBOF and isEOF to SQLCommandMBS class.
- Fixed a possible crash in SQLConnectionMBS destructor.
- Fixed a problem with Options in SQLCommandMBS not reporting options correctly.
- Implemented EOF and BOF for SQL Plugin for RowSets to make for-each loops work better, but AutoCache may need to be enabled if the database doesn't allow MoveFirst like SQLite.
- Version 23.5
- Version 23.4
- Fixed a bug in setting SQLNumericMBS values with floating numbers, caused by a bug fix in version 23.3. Values showed up as zero incorrectly.
- Version 23.3
- Version 23.0
- Fixed a problem with an OutOfBoundsException in Connect method of SQLDatabaseMBS class.
- Version 22.5
- Version 22.3
- Version 22.2
The items on this page are in the following plugins: MBS SQL Plugin.