Monkeybread Realbasic plugin - The class SQLFieldMBS

Platforms to show: All Mac Windows Linux Cross-Platform

The class SQLFieldMBS

class SQLFieldMBS
MBS REALbasic SQL Plugin (SQL), super class: SQLValueReadMBS

class, SQL, MBS REALbasic SQL Plugin (SQL), class SQLFieldMBS, Console safe, Plugin version: 9.3, Mac OS X: Works, Windows: Works, Linux x86: Works, Feedback.

Function: This is the class for a SQL field in a record.
Notes:
Be aware that field objects exists only as long as their SQLCommand exists.
Subclass of the SQLValueReadMBS class.

method FieldNativeType as integer
method FieldPrecision as integer
method FieldScale as integer
method FieldSize as integer
method FieldType as integer
method isFieldRequired as boolean
method Name as string
method Option(name as string) as string
method Pos as integer
method ReadLongOrLob(consumer as SQLDataConsumerMBS, BlockSize as integer)

Methods, properties and events inherited from super classes:

method LongOrLobReaderMode as integer
method asULong as UInt32
class class SQLValueReadMBS
method asUShort as UInt16
method asStringValue as String
method asLong as integer
method asInterval as SQLIntervalMBS
method asString as SQLStringMBS
method asShort as Int16
method asNumeric as SQLNumericMBS
method isNull as boolean
method asLongChar as SQLStringMBS
method asLongBinary as SQLStringMBS
method asBool as boolean
method asBLob as SQLStringMBS
method asBytes as SQLStringMBS
method asCLob as SQLStringMBS
method asDateTime as SQLDateTimeMBS
method asDouble as double
const kDataTypeInterval=9
const kDataTypeDouble=6
const kDataTypeCursor=16
const kDataTypeDateTime=8
const kDataTypeBytes=11
const kDataTypeCLob=15
method DataType as integer
const kDataTypeString=10
const kDataTypeULong=5
const kDataTypeSpecificToDBMS=17
const kDataTypeLongChar=13
const kDataTypeLong=4
const kDataTypeLongBinary=12
const kDataTypeShort=2
const kDataTypeNumeric=7
const kDataTypeBLob=14
const kDataTypeBool=1
const kLongOrLobReaderModeDefault=0
const kLongOrLobReaderModeManual=1
method Constructor(DataType as integer)
const kDataTypeUShort=3
const kDataTypeUnknown=0
method Constructor(value as SQLValueReadMBS)

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/SQLite Benchmark vs REALSQLDatabase

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

Links
MBS Realbasic Plugins - Pfarrgemeinde Messdiener Nickenich