Platforms to show: All Mac Windows Linux Cross-Platform

SQLValueReadMBS class

• 16 properties
  • 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 asText as Text
  • 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
• 14 methods
  • 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 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)
• 20 constants
  • const kDataTypeBLob=14
  • const kDataTypeBool=1
  • const kDataTypeBytes=11
  • const kDataTypeCLob=15
  • const kDataTypeCursor=16
  • const kDataTypeDateTime=8
  • const kDataTypeDouble=6
  • const kDataTypeInterval=9
  • const kDataTypeLong=4
  • const kDataTypeLongBinary=12
  • const kDataTypeLongChar=13
  • const kDataTypeNumeric=7
  • const kDataTypeShort=2
  • const kDataTypeSpecificToDBMS=17
  • const kDataTypeString=10
  • const kDataTypeULong=5
  • const kDataTypeUnknown=0
  • const kDataTypeUShort=3
  • const kLongOrLobReaderModeDefault=0
  • const kLongOrLobReaderModeManual=1

Sub classes:

• class SQLFieldMBS
• class SQLValueMBS
  • class SQLParamMBS

Some methods using this class:

• SQLCommandMBS.Value(index as Integer) as SQLValueReadMBS
• SQLCommandMBS.Value(name as string) as SQLValueReadMBS
• SQLValueMBS.setAsValueRead(value as SQLValueReadMBS)

Some examples which use this class:

• /SQL/MySQL Write blob to file
• /SQL/SQLite Write blob to file

Blog Entries

• MBS Xojo / Real Studio Plugins, version 16.4pr5
• Text data type
• MBS Real Studio Plugins, version 12.5pr4
• MBS Real Studio Plugins, version 11.2pr3

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

SQLValueMBS   -   SSH2ChannelMBS