Platforms to show: All Mac Windows Linux Cross-Platform
SQLFieldMBS.FieldNativeType as Integer
Function:
Returns native type code of the field.
Deprecated. Please use NativeType property instead.
(Read only property)
| 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.
Notes:
Deprecated. Please use NativeType property instead.
(Read only property)
SQLFieldMBS.FieldPrecision as Integer
Function:
Returns precision of the field value (the total number of allowable digits).
Deprecated. Please use Precision property instead.
(Read only property)
| 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.
Notes:
Deprecated. Please use Precision property instead.
(Read only property)
SQLFieldMBS.FieldScale as Integer
Function:
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)
| 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.
Notes:
Deprecated. Please use Scale property instead.
(Read and Write property)
SQLFieldMBS.FieldSize as Integer
Function:
Returns field data size.
Deprecated. Please use Size property instead.
(Read only property)
| 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.
Notes:
Deprecated. Please use Size property instead.
(Read only property)
SQLFieldMBS.FieldType as Integer
Function:
Returns field data type.
Value is one of the kDataType* constants.
Deprecated. Please use Type property instead.
(Read and Write property)
| 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.
Notes:
Value is one of the kDataType* constants.
Deprecated. Please use Type property instead.
(Read and Write property)
SQLFieldMBS.isFieldRequired as boolean
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)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 9.3 | Yes | Yes | Yes | Yes | All |
Notes:
Returns true if the field value can be null; false otherwise.
(Read only property)
SQLFieldMBS.Name as string
Function:
Returns name of the field.
Notes: (Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 9.3 | Yes | Yes | Yes | Yes | All |
Notes: (Read only property)
SQLFieldMBS.NativeType as Integer
Function:
Returns native type code of the field.
Notes: (Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 14.0 | Yes | Yes | Yes | Yes | All |
Notes: (Read only property)
SQLFieldMBS.Options as Dictionary
Function:
Returns a dictionary with all options.
Notes:
For debugging, it may be useful to inspect options in debugger.
(Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 18.4 | Yes | Yes | Yes | Yes | All |
Notes:
For debugging, it may be useful to inspect options in debugger.
(Read only property)
SQLFieldMBS.Pos as Integer
Function:
Returns a one-based position of the field in a result set.
Notes: (Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 9.3 | Yes | Yes | Yes | Yes | All |
Notes: (Read only property)
SQLFieldMBS.Precision as Integer
Function:
Returns precision of the field value (the total number of allowable digits).
Notes: (Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 14.0 | Yes | Yes | Yes | Yes | All |
Notes: (Read only property)
SQLFieldMBS.Scale as Integer
Function:
Returns scale of the field value (the number of digits to the right of the decimal point).
Notes: (Read and Write property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 14.0 | Yes | Yes | Yes | Yes | All |
Notes: (Read and Write property)
SQLFieldMBS.Size as Integer
Function:
Returns field data size.
Notes: (Read only property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 14.0 | Yes | Yes | Yes | Yes | All |
Notes: (Read only property)
SQLFieldMBS.Type as Integer
Function:
Returns field data type.
Example:
Notes:
Value is one of the kDataType* constants.
(Read and Write property)
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| property | SQL | MBS SQL Plugin | 14.0 | Yes | Yes | Yes | Yes | All |
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.
Links
MBS FileMaker tutorial videos
