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 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 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
    • const kCommandTypeSQLStatement = 1
    • const kCommandTypeSQLStatementRaw = 2
    • const kCommandTypeStoredProcedure = 3
    • const kCommandTypeUnknown = 0
    • const kOptionPreFetchRows = "PreFetchRows"
    • const kParamDirTypeInput = 0
    • const kParamDirTypeInputOutput = 1
    • const kParamDirTypeOutput = 2
    • const kParamDirTypeReturn = 3
  • 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)
    • 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 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
    • const kANSILevel0 = 0
    • const kANSILevel1 = 1
    • const kANSILevel2 = 2
    • const kANSILevel3 = 3
    • const kAutoCommitOff = 0
    • const kAutoCommitOn = 1
    • const kAutoCommitUnknown = -1
    • const kClientNotSpecified = 0
    • const kCubeSQLClient = 13
    • const kDB2Client = 6
    • const kDuckDBClient = 14
    • const kErrorBindVarNotFound = 7
    • const kErrorClientInitFails = 6
    • const kErrorClientNotSet = 1
    • const kErrorClientNotSupported = 2
    • const kErrorClientVersionOld = 5
    • const kErrorFieldNotFound = 8
    • const kErrorGetLibraryVersionFails = 4
    • const kErrorLoadLibraryFails = 3
    • const kErrorNoMemory = 0
    • const kErrorUnknownColumnType = 11
    • const kErrorUnknownDataType = 9
    • const kErrorUnknownParameterType = 10
    • const kErrorWrongConversion = 12
    • const kErrorWrongDatetime = 13
    • const kFirebirdClient = 4
    • const kInformixClient = 7
    • const kInterBaseClient = 4
    • const kLevelUnknown = -1
    • const kMariaDBClient = 15
    • const kMySQLClient = 9
    • const kODBCClient = 1
    • const kOptionAPPNAME = "APPNAME"
    • const kOptionLibraryCubeSQL = "CUBESQL.LIBS"
    • const kOptionLibraryDB2 = "DB2CLI.LIBS"
    • const kOptionLibraryDuckDB = "DUCKDB.LIBS"
    • const kOptionLibraryFirebird = "IBASE.LIBS"
    • const kOptionLibraryInformix = "INFCLI.LIBS"
    • const kOptionLibraryInterbase = "IBASE.LIBS"
    • const kOptionLibraryMySQL = "MYSQL.LIBS"
    • const kOptionLibraryODBC = "ODBC.LIBS"
    • const kOptionLibraryOracle = "OCI8.LIBS"
    • const kOptionLibraryPostgreSQL = "LIBPQ.LIBS"
    • const kOptionLibrarySeparator = ":"
    • const kOptionLibrarySQLanywhere = "SQLANY.LIBS"
    • const kOptionLibrarySQLBase = "SQLBASE.LIBS"
    • const kOptionLibrarySQLite = "SQLITE.LIBS"
    • const kOptionLibrarySybaseComn = "SYBCOMN.LIBS"
    • const kOptionLibrarySybaseCS = "SYBCS.LIBS"
    • const kOptionLibrarySybaseCT = "SYBCT.LIBS"
    • const kOptionLibrarySybaseIntl = "SYBINTL.LIBS"
    • const kOptionLibrarySybaseTCL = "SYBTCL.LIBS"
    • const kOptionWSID = "WSID"
    • const kOracleClient = 2
    • const kPostgreSQLClient = 10
    • const kReadCommitted = 1
    • const kReadUncommitted = 0
    • const kRepeatableRead = 2
    • const kSerializable = 3
    • const kSnapshot = 4
    • const kSQLAnywhereClient = 12
    • const kSQLBaseClient = 5
    • const kSQLiteClient = 11
    • const kSQLServerClient = 3
    • const kSybaseClient = 8
    • const SQLiteInMemory = ":memory:"
  • 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 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
    • const kANSILevel0 = 0
    • const kANSILevel1 = 1
    • const kANSILevel2 = 2
    • const kANSILevel3 = 3
    • const kAutoCommitOff = 0
    • const kAutoCommitOn = 1
    • const kAutoCommitUnknown = -1
    • const kCommandTypeSQLStatement = 1
    • const kCommandTypeSQLStatementRaw = 2
    • const kCommandTypeStoredProcedure = 3
    • const kCommandTypeUnknown = 0
    • const kErrorBindVarNotFound = 7
    • const kErrorClientInitFails = 6
    • const kErrorClientNotSet = 1
    • const kErrorClientNotSupported = 2
    • const kErrorClientVersionOld = 5
    • const kErrorFieldNotFound = 8
    • const kErrorGetLibraryVersionFails = 4
    • const kErrorLoadLibraryFails = 3
    • const kErrorNoMemory = 0
    • const kErrorUnknownColumnType = 11
    • const kErrorUnknownDataType = 9
    • const kErrorUnknownParameterType = 10
    • const kErrorWrongConversion = 12
    • const kErrorWrongDatetime = 13
    • const kLevelUnknown = -1
    • const kOptionLibraryCubeSQL = "CUBESQL.LIBS"
    • const kOptionLibraryDB2 = "DB2CLI.LIBS"
    • const kOptionLibraryFirebird = "IBASE.LIBS"
    • const kOptionLibraryInformix = "INFCLI.LIBS"
    • const kOptionLibraryInterbase = "IBASE.LIBS"
    • const kOptionLibraryMySQL = "MYSQL.LIBS"
    • const kOptionLibraryODBC = "ODBC.LIBS"
    • const kOptionLibraryOracle = "OCI8.LIBS"
    • const kOptionLibraryPostgreSQL = "LIBPQ.LIBS"
    • const kOptionLibrarySQLanywhere = "SQLANY.LIBS"
    • const kOptionLibrarySQLBase = "SQLBASE.LIBS"
    • const kOptionLibrarySQLite = "SQLITE.LIBS"
    • const kOptionLibrarySybaseComn = "SYBCOMN.LIBS"
    • const kOptionLibrarySybaseCS = "SYBCS.LIBS"
    • const kOptionLibrarySybaseCT = "SYBCT.LIBS"
    • const kOptionLibrarySybaseIntl = "SYBINTL.LIBS"
    • const kOptionLibrarySybaseTCL = "SYBTCL.LIBS"
    • const kReadCommitted = 1
    • const kReadUncommitted = 0
    • const kRepeatableRead = 2
    • const kSerializable = 3
    • const kSnapshot = 4
    • const SQLiteInMemory = "Sqlite::memory:"
  • class SQLDataConsumerMBS
    • event Write(PieceType as Integer, data as string, Length as UInt32, BlobSize as UInt32)
    • const kFirstPiece = 1
    • const kLastPiece = 3
    • const kNextPiece = 2
    • const kOnePiece = 4
  • class SQLDataProviderMBS
    • event Read(byref PieceType as Integer, Length as UInt32) as string
    • const kFirstPiece = 1
    • const kLastPiece = 3
    • const kNextPiece = 2
    • const kOnePiece = 4
  • 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 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)
    • const LocaleAll=0
    • const LocaleCollate=1
    • const LocaleCType=2
    • const LocaleMessages=6
    • const LocaleMonetary=3
    • const LocaleNumeric=4
    • const LocaleTime=5
  • 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 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
    • const kParamDirTypeInput=0
    • const kParamDirTypeInputOutput=1
    • const kParamDirTypeOutput=2
    • const kParamDirTypeReturn=3
  • 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
    • const kTypeBlob = 16
    • const kTypeBool = 1
    • const kTypeBytes = 13
    • const kTypeClob = 17
    • const kTypeDateTime = 10
    • const kTypeDouble = 8
    • const kTypeInt32 = 4
    • const kTypeInt64 = 6
    • const kTypeInterval = 11
    • const kTypeLong = 4
    • const kTypeLongBinary = 14
    • const kTypeLongChar = 15
    • const kTypeNull = 99
    • const kTypeNumeric = 9
    • const kTypeShort = 2
    • const kTypeString = 12
    • const kTypeUInt32 = 5
    • const kTypeUInt64 = 7
    • const kTypeULong = 5
    • const kTypeUnknown = 0
    • const kTypeUShort = 3
  • 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 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
    • const kDataTypeBlob = 16
    • const kDataTypeBool = 1
    • const kDataTypeBytes = 13
    • const kDataTypeClob = 17
    • const kDataTypeCursor = 18
    • const kDataTypeDateTime = 10
    • const kDataTypeDouble = 8
    • const kDataTypeInt64 = 6
    • const kDataTypeInterval = 11
    • const kDataTypeLong = 4
    • const kDataTypeLongBinary = 14
    • const kDataTypeLongChar = 15
    • const kDataTypeNumeric = 9
    • const kDataTypeShort = 2
    • const kDataTypeSpecificToDBMS = 19
    • const kDataTypeString = 12
    • const kDataTypeUInt64 = 7
    • const kDataTypeULong = 5
    • const kDataTypeUnknown = 0
    • const kDataTypeUShort = 3
    • const kLongOrLobReaderModeDefault = 0
    • const kLongOrLobReaderModeManual = 1
• 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 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

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