Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLFieldMBS class.

SQLFieldMBS.FieldNativeType as Integer   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
Returns native type code of the field.

Deprecated. Please use NativeType property instead.
(Read only property)

SQLFieldMBS.FieldPrecision as Integer   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
Returns precision of the field value (the total number of allowable digits).

Deprecated. Please use Precision property instead.
(Read only property)

SQLFieldMBS.FieldScale as Integer   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
Returns scale of the field value (the number of digits to the right of the decimal point).

Deprecated. Please use Scale property instead.
(Read and Write property)

SQLFieldMBS.FieldSize as Integer   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
Returns field data size.

Deprecated. Please use Size property instead.
(Read only property)

SQLFieldMBS.FieldType as Integer   Deprecated

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
This item is deprecated and should no longer be used.
Returns field data type.

Value is one of the kDataType* constants.
Deprecated. Please use Type property instead.
(Read and Write property)

SQLFieldMBS.isFieldRequired as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Shows if it is possible for the field value to be null.

Returns true if the field value can be null; false otherwise.
(Read only property)

SQLFieldMBS.Name as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns name of the field.

(Read only property)

SQLFieldMBS.NativeType as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns native type code of the field.

(Read only property)

SQLFieldMBS.Options as Dictionary

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 18.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns a dictionary with all options.

For debugging, it may be useful to inspect options in debugger.
(Read only property)

SQLFieldMBS.Pos as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 9.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns a one-based position of the field in a result set.

(Read only property)

SQLFieldMBS.Precision as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns precision of the field value (the total number of allowable digits).

(Read only property)

SQLFieldMBS.Scale as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns scale of the field value (the number of digits to the right of the decimal point).

(Read and Write property)

SQLFieldMBS.Size as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns field data size.

(Read only property)

SQLFieldMBS.Type as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 14.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns field data type.
Example
dim db as SQLConnectionMBS
dim cmd as new SQLCommandMBS(db, "select * from test")

cmd.Execute

dim f as SQLFieldMBS = cmd.Field("test")

if f.Type = f.kDataTypeLong then
MsgBox "type is long"
end if

Value is one of the kDataType* constants.
(Read and Write property)

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


The biggest plugin in space...