Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.
Platforms to show: All Mac Windows Linux Cross-Platform
SQLValueReadMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | Console & Web | iOS |
| class | SQL | MBS SQL Plugin | 9.3 | Yes | Yes | Yes | Yes | No |
- 12 properties
- property asBool as boolean
- property asDouble as Double
- property asLong as Integer
- property asShort as Int16
- property asStringValue as String
- property asText as Text
- 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:
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:
The items on this page are in the following plugins: MBS SQL Plugin.
Links
MBS Xojo Plugins