Platforms to show: All Mac Windows Linux Cross-Platform
SQLFieldMBS class
Super class: SQLValueReadMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | Console & Web | iOS |
class | SQL | MBS SQL Plugin | 9.3 | Yes | Yes | Yes | Yes | No |
Notes:
Be aware that field objects exists only as long as their SQLCommand exists.
Subclass of the SQLValueReadMBS class.
- 15 properties
- property FieldNativeType as Integer
- property FieldPrecision as Integer
- property FieldScale as Integer
- property FieldSize as Integer
- property FieldType as Integer
- 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
- 3 methods
- method ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as Integer)
- method ReadLongOrLob(toFile as FolderItem)
- method ReadLongOrLob(toStream as Writeable)
Super class SQLValueReadMBS
- 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
This class has no sub classes.
Some methods using this class:
- SQLCommandMBS.Field(index as Integer) as SQLFieldMBS
- SQLCommandMBS.Field(name as string) as SQLFieldMBS
Some examples which use this class:
- /SQL/SQLDatabaseMBS Microsoft SQL Server Data Types
- /SQL/SQLite Benchmark vs REALSQLDatabase
- /SQL/Web app/with SQLConnectionMBS
Blog Entries
- MBS Xojo Plugins, version 18.4pr10
- MBS Xojo / Real Studio Plugins, version 16.4pr5
- Upcoming Changes for our SQL Plugin
The items on this page are in the following plugins: MBS SQL Plugin.
Links
MBS Xojo Plugins