Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

SQLFieldMBS.FieldNativeType as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns native type code of the field.
This item is deprecated and should no longer be used.
Notes:
Deprecated. Please use NativeType property instead.
(Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.FieldPrecision as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns precision of the field value (the total number of allowable digits).
This item is deprecated and should no longer be used.
Notes:
Deprecated. Please use Precision property instead.
(Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.FieldScale as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns scale of the field value (the number of digits to the right of the decimal point).
This item is deprecated and should no longer be used.
Notes:
Deprecated. Please use Scale property instead.
(Read and Write property)

Feedback, Comments & Corrections

SQLFieldMBS.FieldSize as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns field data size.
This item is deprecated and should no longer be used.
Notes:
Deprecated. Please use Size property instead.
(Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.FieldType as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns field data type.
This item is deprecated and should no longer be used.
Notes:
Value is one of the kDataType* constants.
Deprecated. Please use Type property instead.
(Read and Write property)

Feedback, Comments & Corrections

SQLFieldMBS.isFieldRequired as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Shows if it is possible for the field value to be null.
Notes:
Returns true if the field value can be null; false otherwise.
(Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Name as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns name of the field.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.NativeType as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Returns native type code of the field.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Options as Dictionary
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 18.4 Yes Yes Yes Yes No
Function: Returns a dictionary with all options.
Notes:
For debugging, it may be useful to inspect options in debugger.
(Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Pos as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns a one-based position of the field in a result set.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Precision as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Returns precision of the field value (the total number of allowable digits).
Notes: (Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Scale as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Returns scale of the field value (the number of digits to the right of the decimal point).
Notes: (Read and Write property)

Feedback, Comments & Corrections

SQLFieldMBS.Size as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Returns field data size.
Notes: (Read only property)

Feedback, Comments & Corrections

SQLFieldMBS.Type as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: 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
Notes:
Value is one of the kDataType* constants.
(Read and Write property)

Feedback, Comments & Corrections

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




Links
MBS Xojo PDF Plugins