The Field virtual table contains information about fields in database tables. The Field virtual table contains the following fields.
Field | Description |
---|---|
TableNo | The ID number for the table. |
No. | The number assigned to the field. |
Table Name | The name of the table. |
FieldName | The name of the field. |
Type | The data type assigned to the field, for example, decimal. |
Len | The length of the field entry in bytes. |
Class | The class of the field, for example, FlowField. |
Enabled | Whether the field is enabled. |
Type Name | The data type assigned to the field. The length of the field entry in bytes is included for Code and Text data types. |
Field Caption | The caption of the field in the language that has been selected. |
RelationTableNo | The ID number for the table that the field is related to. |
RelationFieldNo | The number of the field in another table that the field is related to. |
SQLDataType | The data type assigned to code fields. |
You must create a tabular-type page to access the Field table. The following illustration shows the Field virtual table.