Platforms to show: All Mac Windows Linux Cross-Platform
SQLValueReadMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
- 15 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 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
- 15 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 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)
- 22 constants
- const kDataTypeInt64 = 6
- const kDataTypeUInt64 = 7
Data Types
| Constant | Value | Description |
|---|---|---|
| kDataTypeBlob | 16 |
Data type is BLob data (SQLStringMBS). |
| kDataTypeBool | 1 |
Data type is a boolean. |
| kDataTypeBytes | 13 |
Data type is binary string (SQLStringMBS). |
| kDataTypeClob | 17 |
Data type is CLob data (SQLStringMBS). |
| kDataTypeCursor | 18 |
Data type is Oracle REF CURSOR (SQLCommand). |
| kDataTypeDateTime | 10 |
Data type is SQLDateTime. |
| kDataTypeDouble | 8 |
This is a normal double variable. |
| kDataTypeInterval | 11 |
Data type is an interval (SQLIntervalMBS). |
| kDataTypeLong | 4 |
A 32 bit integer. |
| kDataTypeLongBinary | 14 |
Data type is long binary data (SQLStringMBS). |
| kDataTypeLongChar | 15 |
Data type is long character data (SQLStringMBS). |
| kDataTypeNumeric | 9 |
Data type is SQLNumeric (used internally). |
| kDataTypeShort | 2 |
Data type is a 16 bit signed integer. |
| kDataTypeSpecificToDBMS | 19 |
Data type is server-specific. |
| kDataTypeString | 12 |
Data type is character string (SQLString). |
| kDataTypeULong | 5 |
Data type is a 32 bit unsigned integer. |
| kDataTypeUnknown | 0 |
Data type is unknown. |
| kDataTypeUShort | 3 |
A 16 bit unsigned integer. |
Read Modes
| Constant | Value | Description |
|---|---|---|
| kLongOrLobReaderModeDefault | 0 |
Long or Lob(CLob) data reading mode is default (automatic). |
| kLongOrLobReaderModeManual | 1 |
Long or Lob(CLob) data reading mode is manual. |
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 using this class:
Blog Entries
- MBS Xojo Plugins, version 20.5pr9
- MBS Xojo Plugins, version 20.5pr7
- MBS Xojo Plugins, version 19.5pr2
- MBS Xojo Plugins in version 19.2
- MBS Xojo Plugins, version 19.2pr1
- MBS Xojo / Real Studio Plugins, version 16.4pr5
- Text data type
- MBS Real Studio Plugins, version 12.5pr4
- Release notes for SQL or ChartDirector?
- MBS Real Studio Plugins, version 11.2pr3
The items on this page are in the following plugins: MBS SQL Plugin.
Links
MBS FileMaker tutorial videos
