Field Virtual Table
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.
.jpg "Field Virtual table")
Note
For performance reasons, in pages that use the Field virtual table, the RelationFieldNo field is blank for fields with complex table relations. To parse all fields that have any table relationships is time consuming. Accordingly, data such as complex table relations is not available in windows such as the RapidStart Services configuration worksheet.