Platforms to show: All Mac Windows Linux Cross-Platform

SQLFieldMBS class

Super class: SQLValueReadMBS

• 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

• 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

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 19.2pr1
• 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.

SQLErrorExceptionMBS   -   SQLGlobalsMBS