Platforms to show: All Mac Windows Linux Cross-Platform

The plugin MBS SQL Plugin:

• 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
  • method AddRow(TableName as String, row as DatabaseRow, idColumnName as string = "") as Integer
  • 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 DB2MBS
  • method SQLRowCount(cmd as SQLCommandMBS) as Int64
  • method SQLExecDirect(cmd as SQLCommandMBS, text as string)
  • property Lasterror as Integer
• class InformixMBS
  • method Error(cmd as SQLCommandMBS, byref SQLState as string, byref NativeError as integer, byref ErrorMsg as string) as integer
  • method GetCursorName(cmd as SQLCommandMBS) as string
  • method SetCursorName(cmd as SQLCommandMBS, name as string) as boolean
  • method HSTMT(cmd as SQLCommandMBS) as integer
  • method HENV as integer
  • method HDBC as integer
• class MySQLMBS
  • method SetSSL(keyPath as string, CertificatePath as string, AuthorityPath as string, authorityFolderPath as string, Cipher as string)
  • method InsertID as Int64
  • method FieldCount as UInt32
  • method AffectedRows as UInt64
  • method Info as string
  • method Error as string
  • method ErrorNumber as UInt32
  • method NumberOfRows(cmd as SQLCommandMBS) as UInt64
• class PostgreSQLAPIMBS
  • method DB as string
  • method User as string
  • method Password as string
  • method Host as string
  • method Port as string
  • method TTY as string
  • method Options as string
  • method ErrorMessage as string
  • method RecordCount(cmd as SQLCommandMBS) as integer
  • method FieldCount(cmd as SQLCommandMBS) as integer
  • method Field(cmd as SQLCommandMBS, RecordIndex as integer, FieldIndex as integer) as string
  • method Field(cmd as SQLCommandMBS, RecordIndex as integer, FieldName as string) as string
• class RecordSet
  • method CloneMBS as RecordSet
• class SQLAPIMBS
  • property Connection as Variant
  • property ClassName as String
• class SQLBLobMBS
  • method Constructor(Data as MemoryBlock)
  • method Constructor(Data as string, isText as boolean = true)
  • method Constructor
  • method Constructor(data as SQLStringMBS)
  • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
• class SQLBytesMBS
  • method Constructor(Data as MemoryBlock)
  • method Constructor(Data as string, isText as boolean = true)
  • method Constructor
  • method Constructor(data as SQLStringMBS)
• class SQLCLobMBS
  • method Constructor(Data as string, isText as boolean=true)
  • method Constructor
  • method Constructor(data as SQLStringMBS)
  • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
• class SQLCommandMBS
  • method PostgreSQLRowCount as Integer
  • method PostgreSQLFieldCount as Integer
  • method PostgreSQLField(RecordIndex as integer, FieldIndex as integer) as string
  • method PostgreSQLField(RecordIndex as integer, FieldName as string) as string
  • method DB2SQLRowCount as Int64
  • method DB2SQLExecDirect(sql as string)
  • method FieldNames as String()
  • method AsRecordSet as RecordSet
  • 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 CreateParam(name as string, ParamType as integer, DirType as integer=0) as SQLParamMBS
  • method FieldExists(name as string) as Boolean
  • method Field(name as string) as SQLFieldMBS
  • method Field(index as integer) as SQLFieldMBS
  • method Value(name as string) as SQLValueReadMBS
  • method Value(index as integer) as SQLValueReadMBS
  • method Param(name as string) as SQLParamMBS
  • method ParamByIndex(index as integer) as SQLParamMBS
  • method Param(ID as integer) as SQLParamMBS
  • method Constructor
  • method Constructor(connection as SQLConnectionMBS, SQLCommand as String, CommandType as integer = 0)
  • method DestroyParams
  • method Cancel
  • method Open
  • method Close
  • method Execute
  • method ExecuteCommand(SQLCommand as string, CommandType as integer=0)
  • method ExecuteMT
  • method ExecuteCommandMT(SQLCommand as string, CommandType as integer=0)
  • method SetParameters(Params as dictionary)
  • method Prepare
  • method Cache
  • method FetchNext as boolean
  • method FetchPrior as boolean
  • method FetchFirst as boolean
  • method FetchPos(offset as Integer, relative as boolean = false) as boolean
  • method FetchLast as boolean
  • method setCommandText(SQLCommand as string, CommandType as integer = 0)
  • method AsRowSet as RowSet
  • property Option(name as string) as string
  • property CommandType as Integer
  • property RowsAffected as Integer
  • property FieldCount as Integer
  • property ParamCount as Integer
  • property CommandText as String
  • property isOpened as Boolean
  • property isResultSet as Boolean
  • property isExecuted as Boolean
  • property isExecuting as Boolean
  • property isEOF as Boolean
  • property isBOF as Boolean
  • property hasCache as Boolean
  • property Connection as SQLConnectionMBS
  • property Tag as Variant
  • property Fields as Dictionary
  • property Parameters as Dictionary
  • property Options as Dictionary
  • shared property CommandCount as Integer
  • event Working
  • event Trace(traceInfo as integer, SQL as string)
• class SQLConnectionMBS
  • method SQLiteConnectionHandle as Ptr
  • 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 SQLiteLibVersion as String
  • 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 Listen
  • method SQLSelectAsRecordSet(command as string, CommandType as integer = 0) as RecordSet
  • method SQLSelectAsRecordSetMT(command as string, CommandType as integer = 0) as RecordSet
  • method SQLSelect(command as string, CommandType as integer = 0) as string
  • method SQLExecute(command as string, CommandType as integer = 0)
  • method SQLSelectMT(command as string, CommandType as integer = 0) as string
  • method SQLExecuteMT(command as string, CommandType as integer = 0)
  • method SetFileOption(name as string, file as folderitem)
  • method Disconnect
  • method Commit
  • method Rollback
  • 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 InsertRecord(TableName as String, Record as Dictionary)
  • method UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)
  • method BeginTransaction
  • method SQLSelectAsRowSet(command as string, CommandType as integer = 0) as RowSet
  • method SQLSelectAsRowSetMT(command as string, CommandType as integer = 0) as RowSet
  • property Option(name as string) as string
  • property Tag as Variant
  • property Error as Boolean
  • property ErrorCode as Integer
  • property ErrorMessage as String
  • property isConnected as Boolean
  • property isAlive as Boolean
  • property ServerVersion as Integer
  • property ClientVersion as Integer
  • property IsolationLevel as Integer
  • property Client as Integer
  • property AutoCommit as Integer
  • property ServerVersionString as String
  • property NativeAPI as Variant
  • property RaiseExceptions as Boolean
  • property Scrollable as Boolean
  • property LastStatement as String
  • property SQLiteEncryptionKey as String
  • property Options as Dictionary
  • property RowsAffected as Integer
  • shared method kOptionLibrarySeparator as String
  • shared property ConnectionCount as Integer
  • shared property VariantsKeepSQLObjects as Boolean
  • event Working
  • 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 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 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(other as SQLDateTimeMBS)
  • 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 Constructor(Hour as integer, Minute as integer, Second as integer = 0, Fraction as Integer = 0)
  • method Constructor(DateValue as Date)
  • method Set(value as Date)
  • method Constructor(StringValue as String)
  • method Constructor(DateTimeValue as DateTime)
  • method Set(DateTimeValue as DateTime)
  • property StringValue as String
  • property TimeZone as String
  • property DoubleValue as Double
  • property Year as Integer
  • property Month as Integer
  • property Hour as Integer
  • property Minute as Integer
  • property Second as Integer
  • property Day as Integer
  • property DayOfWeek as Integer
  • property DayOfYear as Integer
  • property Fraction as Integer
  • property DateValue as Date
  • property hasDate as Boolean
  • property hasTime as Boolean
  • property DateTimeValue as DateTime
• class SQLErrorExceptionMBS
  • property ErrorClass as Integer
  • property NativeError as Integer
  • property ErrorPosition as Integer
  • property ErrorMessage as String
  • 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 Option(name as string) as string
  • property Name as String
  • property Pos as Integer
  • property Size as Integer
  • property Type as Integer
  • property NativeType as Integer
  • property Scale as Integer
  • property Precision as Integer
  • property isFieldRequired as Boolean
  • property FieldSize as Integer
  • property FieldType as Integer
  • property FieldNativeType as Integer
  • property FieldScale as Integer
  • property FieldPrecision as Integer
  • property Options as Dictionary
• class SQLGlobalsMBS
  • shared method UnInitialize
  • shared method FindTableName(SQL as String) as String
  • shared method SetCurrentWorkingDirectory(path as folderitem) as boolean
  • shared method SetCurrentWorkingDirectory(path as String) as boolean
  • shared method RaiseException(message as string)
  • shared method RaiseSQLErrorException(UserCode as integer, message as string)
  • shared method UnSetEnv(name as string) as boolean
  • shared method PutEnv(line as string) as boolean
  • shared method SetEnv(name as string, value as string) as boolean
  • shared method GetEnv(name as string) as string
  • shared method SetLicenseCode(n as string, enddate as integer, v1 as integer, v2 as integer)
  • shared method GetVersionMajor as integer
  • shared method GetVersionMinor as integer
  • shared method GetVersionBuild as integer
  • shared method GetVersion as String
  • shared method Setlocale(category as integer, locale as string)
  • event Trace(traceInfo as integer, SQL as string, Connection as SQLConnectionMBS, Command as SQLCommandMBS)
• class SQLIntervalMBS
  • method Constructor
  • method Constructor(value as double)
  • method Constructor(days as integer, hours as integer, minutes as integer, seconds as integer = 0, NanoSeconds as Integer = 0)
  • 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 StringValue as String
  • property DoubleValue as Double
  • property TotalDays as Double
  • property TotalHours as Double
  • property TotalMinutes as Double
  • property TotalSeconds as Double
  • property Days as Integer
  • property Hours as Integer
  • property Minutes as Integer
  • property Seconds as Integer
  • property Fraction as Integer
• class SQLite3BackupMBS
  • method Constructor
  • property Handle as Integer
• class SQLite3MBS
  • method MemoryHighwater(reset as boolean) as Int64
  • method SetBusyTimeout(TimeOutMS as Integer = 20)
  • method SetBusyHandler(MaxAttempts as Integer = 5)
  • method ReKey(Key as String) as Integer
  • method SetKey(Key as String) as Integer
  • method LoadExtension(path as String, ByRef ErrorMessage as String) as Integer
  • method LoadExtension(file as FolderItem, ByRef ErrorMessage as String) as Integer
  • method EnableLoadExtension(OnOff as boolean)
  • method Threadsafe 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 BackupPageCount(Backup as SQLite3BackupMBS) as integer
  • method BackupRemaining(Backup as SQLite3BackupMBS) as integer
  • method BackupFinish(Backup as SQLite3BackupMBS) as integer
  • method BackupStep(Backup as SQLite3BackupMBS, Pages as Integer) as integer
  • method BackupInit(Dest as Variant, DestName as String, Source as Variant, SourceName as String) as SQLite3BackupMBS
  • method ErrCode as integer
  • method ErrMessage as string
  • method LastInsertRowID as Int64
  • property Version as String
  • property VersionNumber as Integer
  • property MemoryUsed as Int64
  • property MemoryHighwater as Int64
  • property ConnectionHandle as Ptr
• class SQLiteFunctionMBS
  • method ResultText(text as string)
  • method ResultNull
  • method ResultBlob(text as string)
  • method ResultBlob(data as MemoryBlock)
  • method ResultBlob(data as ptr, size as Integer)
  • method ResultInteger(value as Integer)
  • method ResultDouble(value as Double)
  • method ResultZeroBlob(Length as Integer)
  • method ResultError(ErrorMessage as string)
  • method ResultErrorCode(ErrorCode as Integer)
  • method Destructor
  • method Constructor
  • property Flags as Integer
  • property ArgumentCount as Integer
  • property DatabaseCount as Integer
  • property Name as String
  • property CallCounter as Integer
  • property Enabled as Boolean
  • event Perform(ArgumentCount as Integer, Arguments() as Variant)
• class SQLLongBinaryMBS
  • method Constructor(Data as MemoryBlock)
  • method Constructor(Data as string, isText as boolean = true)
  • method Constructor
  • method Constructor(data as SQLStringMBS)
  • method Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
• class SQLLongCharMBS
  • method Constructor(Data as string, isText as boolean=true)
  • method Constructor
  • method Constructor(data as SQLStringMBS)
  • 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)
  • property CurrencyValue as Currency
  • property DoubleValue as Double
  • property Int64Value as Int64
  • property UInt64Value as UInt64
  • property StringValue as String
  • property Precision as Integer
  • property Scale as Integer
  • property Sign as Integer
  • shared method NumericWithCurrency(value as Currency) as SQLNumericMBS
  • shared method NumericWithDouble(value as double) as SQLNumericMBS
  • shared method NumericWithString(value as string) as SQLNumericMBS
  • shared method NumericWithInt64(value as Int64) as SQLNumericMBS
  • shared method NumericWithUInt64(value as UInt64) as SQLNumericMBS
• class SQLParamMBS
  • method ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as integer)
  • method ReadLongOrLob(toFile as FolderItem)
  • method ReadLongOrLob(toStream as Writeable)
  • property Option(name as string) as string
  • property Name as String
  • property Precision as Integer
  • property Scale as Integer
  • property DirType as Integer
  • property Size as Integer
  • property NativeType as Integer
  • property Type as Integer
  • property Options as Dictionary
  • property IsInput as Boolean
  • property IsOutput as Boolean
• class SQLPositionMBS
  • method Constructor(withID as integer)
  • method Constructor(withName 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
• class SQLStringMBS
  • method Constructor(Data as MemoryBlock)
  • method Constructor
  • method Constructor(other as SQLStringMBS)
  • method Constructor(Data as string, isText as Boolean = true)
  • method Operator_Convert(Text as string)
  • method Operator_Convert as string
  • method CopyText as string
  • method CopyBinaryData as string
  • method CopyMemoryBlock as MemoryBlock
  • method GetBinaryLength as UInt32
  • method GetLength as UInt32
  • method Empty
  • method MakeUpper
  • method MakeLower
  • method TrimRight
  • method TrimLeft
  • 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 Mid(first as integer) as SQLStringMBS
  • method Mid(first as integer, Count as integer) as SQLStringMBS
  • method Left(count as integer) as SQLStringMBS
  • method Right(count as integer) as SQLStringMBS
  • property IsEmpty as Boolean
  • property BinaryLength as UInt32
  • property Length as UInt32
  • property DebugText as String
• class SQLUnsupportedExceptionMBS
• class SQLValueMBS
  • method Constructor(DataType as integer)
  • method setAsNull
  • method setAsDefault
  • method setAsUnknown
  • method setAsBool(value as boolean)
  • method setAsShort(value as Int16)
  • method setAsUShort(value as UInt16)
  • method setAsLong(value as Int32)
  • method setAsULong(value as UInt32)
  • method setAsDouble(value as double)
  • method setAsNumeric(value as SQLNumericMBS)
  • method setAsDateTime(value as SQLDateTimeMBS)
  • method setAsDate(value as date)
  • method setAsInterval(value as SQLIntervalMBS)
  • method setAsValueRead(value as SQLValueReadMBS)
  • method setAsInt32(value as Int32)
  • method setAsUInt32(value as UInt32)
  • method setAsInt64(value as Int64)
  • method setAsInteger(value as Integer)
  • method setAsBytes(value as SQLBytesMBS)
  • method setAsBytes(value as SQLStringMBS)
  • method setAsBytes(data as string)
  • method setAsBytes(data as MemoryBlock)
  • method setAsBlob(data as SQLStringMBS)
  • method setAsBlob(data as string)
  • method setAsBlob(data as MemoryBlock)
  • method setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
  • method setAsBlob(file as folderItem)
  • method setAsBlob(stream as Readable)
  • method setAsClob(text as SQLStringMBS)
  • method setAsClob(text as string)
  • method setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
  • method setAsClob(data as MemoryBlock)
  • method setAsClob(file as folderItem)
  • method setAsClob(stream as Readable)
  • method setAsLongBinary(data as SQLStringMBS)
  • method setAsLongBinary(data as string)
  • method setAsLongBinary(data as MemoryBlock)
  • method setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
  • method setAsLongBinary(file as folderItem)
  • method setAsLongBinary(stream as Readable)
  • method setAsLongChar(text as SQLStringMBS)
  • method setAsLongChar(text as string)
  • method setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
  • method setAsLongChar(data as MemoryBlock)
  • method setAsLongChar(file as folderItem)
  • method setAsLongChar(stream as Readable)
  • method setAsString(value as SQLStringMBS)
  • method setAsString(value as string)
  • method setAsString(data as MemoryBlock)
  • method setVariant(value as variant)
  • method setAsDateTime(value as dateTime)
  • property isDefault as Boolean
• class SQLValueReadMBS
  • method Constructor(DataType as integer)
  • method Constructor(value as SQLValueReadMBS)
  • method asNumeric as SQLNumericMBS
  • method asDateTime as SQLDateTimeMBS
  • method asDate as Date
  • method asInterval as SQLIntervalMBS
  • method asString as SQLStringMBS
  • method asBytes as SQLStringMBS
  • method asLongBinary as SQLStringMBS
  • method asLongChar as SQLStringMBS
  • method asBLob as SQLStringMBS
  • method asCLob as SQLStringMBS
  • method asBLobString as String
  • method asBLobMemory as MemoryBlock
  • method asDateTimeValue as DateTime
  • property DataType as Integer
  • property isNull as Boolean
  • property asVariant as variant
  • property asStringValue as String
  • property asBool as Boolean
  • property asShort as Int16
  • property asUShort as UInt16
  • property asLong as Int32
  • property asULong as UInt32
  • property asDouble as double
  • property LongOrLobReaderMode as Integer
  • property asInteger as Integer
  • property asInt32 as Int32
  • property asInt64 as Int64
  • property asUInt32 as UInt32
• module InternalCubeSQLLibraryMBS
• method Use as boolean
• method Version as String
• method SSLVersion as String
• module InternalPostgreSQLLibraryMBS
• method Use as boolean
• method Version as Integer
• method OpenSSLVersion as String
• module InternalSQLiteLibraryMBS
• method LoadICU as Boolean
• method isKeyword(name as string) as boolean
• method Keywords as String()
• method Use as boolean
• method Version as String
• method SourceID as String
• method VersionNumber as Integer
• 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)
• 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