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 in the SQL Server Option.

You must create a tabular-type form to access the Field table.

Dd301354.Local_2079195005_nav_adg_8_table_48(en-us,NAV.60).gif

See Also

Concepts

C/SIDE Virtual Tables