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
  • BuildRecordSetMBS(fieldNames() as string, values() as string) as RecordSet
  • BuildRowSetMBS(fieldNames() as string, values() as string) as RowSet
  • CloneRecordSetMBS(rec as RecordSet) as RecordSet
• Classes
  • class Database
    • method AddRow(TableName as String, row as DatabaseRow)
    • method AddRow(TableName as String, row as DatabaseRow, idColumnName as string = "") as Integer
    • method BeginTransaction
    • method Close
    • method Commit
    • method CommitTransaction
    • method Connect
    • method Connect as boolean
    • method ExecuteSQL(sql As String, ParamArray values As Variant)
    • method ExecuteSQL(sql As String, values() As Variant)
    • method InsertRecord(TableName as String, Data as DatabaseRecord)
    • method Prepare(statement as String) as PreparedSQLStatement
    • method Rollback
    • method RollbackTransaction
    • method SelectSQL(sql As String, ParamArray values As Variant) as RowSet
    • method SelectSQL(sql As String, values() As Variant) as RowSet
    • method SQLExecute(ExecuteString as string)
    • method SQLSelect(SelectString as string) as RecordSet
    • property DatabaseName as String
    • property Error as Boolean
    • property ErrorCode as Integer
    • property ErrorMessage as String
    • property Host as String
    • property Password as String
    • property UserName as String
  • class SQLBLobMBS
    • method Constructor
    • method Constructor(Data as MemoryBlock)
    • method Constructor(data as SQLStringMBS)
    • method Constructor(Data as string, isText as Boolean = True)
    • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
  • class SQLBytesMBS
    • method Constructor
    • method Constructor(Data as MemoryBlock)
    • method Constructor(data as SQLStringMBS)
    • method Constructor(Data as string, isText as Boolean = True)
  • class SQLCLobMBS
    • method Constructor
    • method Constructor(data as SQLStringMBS)
    • method Constructor(Data as string, isText as boolean=true)
    • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
  • 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
    • property ErrorClass as Integer
    • property ErrorMessage as String
    • property ErrorPosition as Integer
    • property NativeError as Integer
    • property SQL as String
  • class SQLFieldMBS
    • method ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as Integer)
    • method ReadLongOrLob(toFile as FolderItem)
    • method ReadLongOrLob(toStream as Writeable)
    • property isFieldRequired as boolean
    • property Name as string
    • property NativeType as Integer
    • property Options as Dictionary
    • property Pos as Integer
    • property Precision as Integer
    • property Scale as Integer
    • property Size as Integer
    • property Type as Integer
    • property Option(name as string) as string
  • class SQLGlobalsMBS
    • shared method FindTableName(SQL as String) as String
    • shared method GetEnv(name as string) as string
    • shared method GetVersion as String
    • shared method GetVersionBuild as Integer
    • shared method GetVersionMajor as Integer
    • shared method GetVersionMinor as Integer
    • shared method PutEnv(line as string) as boolean
    • shared method RaiseException(message as string)
    • shared method RaiseSQLErrorException(UserCode as Integer, message as string)
    • shared method SetCurrentWorkingDirectory(path as folderitem) as boolean
    • shared method SetCurrentWorkingDirectory(path as String) as boolean
    • shared method SetDllDirectory(path as folderitem) as boolean
    • shared method SetDllDirectory(path as String) as boolean
    • shared method SetEnv(name as string, value as string) as boolean
    • shared method SetLicenseCode(n as string, enddate as Integer, v1 as Integer, v2 as Integer)
    • shared method Setlocale(category as Integer, locale as string)
    • shared method UnInitialize
    • shared method UnSetEnv(name as string) as boolean
    • event Trace(traceInfo as Integer, SQL as string, Connection as SQLConnectionMBS, Command as SQLCommandMBS)
  • class SQLIntervalMBS
    • method Constructor
    • method Constructor(days as Integer, hours as Integer, minutes as Integer, seconds as Integer = 0, NanoSeconds as Integer = 0)
    • method Constructor(value as Double)
    • method Dec(interval as SQLIntervalMBS)
    • method Inc(interval as SQLIntervalMBS)
    • method SetInterval(days as Integer, hours as Integer, minutes as Integer, seconds as Integer = 0, NanoSeconds as Integer = 0)
    • property Days as Integer
    • property DoubleValue as Double
    • property Fraction as Integer
    • property Hours as Integer
    • property Minutes as Integer
    • property Seconds as Integer
    • property StringValue as string
    • property TotalDays as Double
    • property TotalHours as Double
    • property TotalMinutes as Double
    • property TotalSeconds as Double
  • class SQLite3BackupMBS
    • method Constructor
    • property Handle as Integer
  • class SQLiteFunctionMBS
    • method Constructor
    • method Destructor
    • method ResultBlob(data as MemoryBlock)
    • method ResultBlob(data as ptr, size as Integer)
    • method ResultBlob(text as string)
    • method ResultDouble(value as Double)
    • method ResultError(ErrorMessage as string)
    • method ResultErrorCode(ErrorCode as Integer)
    • method ResultInteger(value as Integer)
    • method ResultNull
    • method ResultText(text as string)
    • method ResultZeroBlob(Length as Integer)
    • property ArgumentCount as Integer
    • property CallCounter as Integer
    • property DatabaseCount as Integer
    • property Enabled as Boolean
    • property Flags as Integer
    • property Name as String
    • event Perform(ArgumentCount as Integer, Arguments() as Variant)
  • class SQLLongBinaryMBS
    • method Constructor
    • method Constructor(Data as MemoryBlock)
    • method Constructor(data as SQLStringMBS)
    • method Constructor(Data as string, isText as Boolean = True)
    • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
  • class SQLLongCharMBS
    • method Constructor
    • method Constructor(data as SQLStringMBS)
    • method Constructor(Data as string, isText as boolean=true)
    • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
  • class SQLLongOrLobMBS
  • class SQLNotInitializedExceptionMBS
  • class SQLNullMBS
  • class SQLNumericMBS
    • method Constructor
    • method Constructor(value as Double)
    • method Constructor(value as string)
    • shared method NumericWithCurrency(value as Currency) as SQLNumericMBS
    • shared method NumericWithDouble(value as Double) as SQLNumericMBS
    • shared method NumericWithInt64(value as Int64) as SQLNumericMBS
    • shared method NumericWithString(value as string) as SQLNumericMBS
    • shared method NumericWithUInt64(value as UInt64) as SQLNumericMBS
    • property CurrencyValue as Currency
    • property DoubleValue as Double
    • property Int64Value as Int64
    • property precision as Integer
    • property scale as Integer
    • property sign as Integer
    • property StringValue as string
    • property UInt64Value as UInt64
  • class SQLParamMBS
    • method ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as Integer)
    • method ReadLongOrLob(toFile as FolderItem)
    • method ReadLongOrLob(toStream as Writeable)
    • property DirType as Integer
    • property IsInput as Boolean
    • property IsOutput as Boolean
    • property Name as string
    • property NativeType as Integer
    • property Options as Dictionary
    • property Precision as Integer
    • property Scale as Integer
    • property Size as Integer
    • property Type as Integer
    • property Option(name as string) as string
  • class SQLPositionMBS
    • method Constructor(withID as Integer)
    • method Constructor(withName as string)
  • 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
    • method Compare(text as SQLStringMBS) as Integer
    • method Compare(text as string) as Integer
    • method CompareNoCase(text as SQLStringMBS) as Integer
    • method CompareNoCase(text as string) as Integer
    • method Constructor
    • method Constructor(Data as MemoryBlock)
    • method Constructor(Data as string, isText as Boolean = True)
    • method Constructor(other as SQLStringMBS)
    • method CopyBinaryData as string
    • method CopyMemoryBlock as MemoryBlock
    • method CopyText as string
    • method Empty
    • method Left(count as Integer) as SQLStringMBS
    • method MakeLower
    • method MakeUpper
    • method Mid(first as Integer) as SQLStringMBS
    • method Mid(first as Integer, Count as Integer) as SQLStringMBS
    • method Operator_Convert as string
    • method Operator_Convert(text as string)
    • method Right(count as Integer) as SQLStringMBS
    • method TrimLeft
    • method TrimRight
    • property BinaryLength as UInt32
    • property DebugText as String
    • property IsEmpty as boolean
    • property Length as UInt32
  • class SQLUnsupportedExceptionMBS
  • class SQLValueMBS
    • method Constructor(DataType as Integer)
    • method setAsBlob(data as MemoryBlock)
    • method setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
    • method setAsBlob(data as SQLStringMBS)
    • method setAsBlob(data as string)
    • method setAsBlob(file as folderItem)
    • method setAsBlob(stream as Readable)
    • method setAsBool(value as boolean)
    • method setAsBytes(data as MemoryBlock)
    • method setAsBytes(data as string)
    • method setAsBytes(value as SQLBytesMBS)
    • method setAsBytes(value as SQLStringMBS)
    • method setAsClob(data as MemoryBlock)
    • method setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
    • method setAsClob(file as folderItem)
    • method setAsClob(stream as Readable)
    • method setAsClob(text as SQLStringMBS)
    • method setAsClob(text as string)
    • method setAsDate(value as date)
    • method setAsDateTime(value as dateTime)
    • method setAsDateTime(value as SQLDateTimeMBS)
    • method setAsDefault
    • method setAsDouble(value as Double)
    • method setAsInt32(value as Int32)
    • method setAsInt64(value as Int64)
    • method setAsInteger(value as Integer)
    • method setAsInterval(value as SQLIntervalMBS)
    • method setAsLong(value as Int32)
    • method setAsLongBinary(data as MemoryBlock)
    • method setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
    • method setAsLongBinary(data as SQLStringMBS)
    • method setAsLongBinary(data as string)
    • method setAsLongBinary(file as folderItem)
    • method setAsLongBinary(stream as Readable)
    • method setAsLongChar(data as MemoryBlock)
    • method setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
    • method setAsLongChar(file as folderItem)
    • method setAsLongChar(stream as Readable)
    • method setAsLongChar(text as SQLStringMBS)
    • method setAsLongChar(text as string)
    • method setAsNull
    • method setAsNumeric(value as SQLNumericMBS)
    • method setAsShort(value as Int16)
    • method setAsString(data as MemoryBlock)
    • method setAsString(value as SQLStringMBS)
    • method setAsString(value as string)
    • method setAsUInt32(value as UInt32)
    • method setAsULong(value as UInt32)
    • method setAsUnknown
    • method setAsUShort(value as UInt16)
    • method setAsValueRead(value as SQLValueReadMBS)
    • method setVariant(value as Variant)
    • property isDefault as boolean
  • class SQLValueReadMBS
    • method asBLob as SQLStringMBS
    • method asBLobMemory as MemoryBlock
    • method asBLobString as String
    • method asBytes as SQLStringMBS
    • method asCLob as SQLStringMBS
    • method asDate as Date
    • method asDateTime as SQLDateTimeMBS
    • method asDateTimeValue as DateTime
    • method asInterval as SQLIntervalMBS
    • method asLongBinary as SQLStringMBS
    • method asLongChar as SQLStringMBS
    • method asNumeric as SQLNumericMBS
    • method asString as SQLStringMBS
    • method Constructor(DataType as Integer)
    • method Constructor(value as SQLValueReadMBS)
    • property asBool as boolean
    • property asDouble as Double
    • property asInt32 as Int32
    • property asInt64 as Int64
    • property asInteger as Integer
    • property asLong as Int32
    • property asShort as Int16
    • property asStringValue as String
    • property asUInt32 as UInt32
    • property asULong as UInt32
    • property asUShort as UInt16
    • property asVariant as Variant
    • property DataType as Integer
    • property isNull as boolean
    • property LongOrLobReaderMode as Integer
• Class Extensions
  • class RecordSet
    • method CloneMBS as RecordSet
• Modules
  • module InternalCubeSQLLibraryMBS
    • method SSLVersion as String
    • method Use as boolean
    • method Version as String
  • 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 DumpToStrings(SqliteDBConectionHandle as Ptr, SchemaName as String = "", TableName as string = "") as String()
    • 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 Base64ExtensionEnabled as Boolean
    • property CSVExtensionEnabled as Boolean
    • property ICUEnabled as Boolean
    • property ICULoaded as Boolean
    • property ICUUsed as Boolean
    • property MemoryHighwater as Int64
    • property MemoryUsed as Int64
    • property Path as String
    • property UUIDExtensionEnabled as Boolean

Release notes

• Version 25.4
  • Added kOLEDBClient constant for SQLConnectionMBS class.
  • Added OLEDB: prefix for SQLDatabaseMBS class.
• Version 25.3
  • Added CSV extension for the built-in SQLite library in InternalSQLiteLibraryMBS module.
  • Added DumpToStrings method to InternalSQLiteLibraryMBS module.
  • Added uuid and base64 extensions for the built-in SQLite library in InternalSQLiteLibraryMBS module.
  • Added UUIDExtensionEnabled and Base64ExtensionEnabled properties to InternalSQLiteLibraryMBS module.
• Version 25.2
  • Fixed BOF of RecordSet when used with our SQLDatabaseMBS class to report BOF = true on the first row of the result set.
• Version 25.1
  • Added SetDllDirectory function to SQLGlobalsMBS module.
  • Fixed an issue in SQLGlobalsMBS being deallocated too early.
  • Fixed memory leak in SQLDatabaseMBS where tag value was not freed in destructor.
• Version 24.5
  • Added MYSQL_OPT_LOCAL_INFILE option for SQLConnectionMBS and SQLDatabaseMBS classes for MySQL connections.
• Version 24.3
  • Added AddRow() variant to SQLDatabaseMBS with returning insert id.
• Version 24.2
  • Improved thread safety for SQLConnectionMBS class.
• Version 24.1
  • Added SQLiteFunctionMBS class to add custom SQLite functions for SQLite database connections.
  • Added Path property to InternalSQLiteLibraryMBS module.
  • Changed kOptionLibrarySeparator in SQLConnectionMBS class to be a shared method to return ";" on Windows and ":" on macOS/Linux.
  • Updated our Unicode extension for SQLite in InternalSQLiteLibraryMBS class to work in Xojo 2024r1 on Windows.
• 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.

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