Monkeybread Xojo plugin - SQLValueReadMBS class

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

The class used in the SQL Plugin for value objects which can be read.

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

Constants

Constant	Value	Description
kDataTypeInt64	6	One of the field type constants Signed 64-bit integer.
kDataTypeUInt64	7	One of the field type constants Unsigned 64-bit integer.

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

Release notes

Version 20.5
- Added asDateTimeValue to SQLValueReadMBS class to return DateTime object.
Version 19.5
- Added kDataTypeInt64 and kDataTypeUInt64 constants to SQLValueReadMBS class.
Version 19.2
- Added asInt32, asInteger, asInt64, asUInt32 to SQLValueReadMBS class.

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

SQLValueMBS - SSH2ChannelMBS

💬 Ask a question or report a problem

The biggest plugin in space...