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 in the SQL Server Option. |
You must create a tabular-type form to access the Field table.