DF_FIELD_NUMBER

See Also: Get_Attribute, Set_Attribute, Field_Map, DF_FIELD_NAME

 

The number of a field within a table.

Level

Column

Supported by

All Drivers

Type

Integer, temporary

Access

Read Only

Values

0 ~ maximum fields allowed in database

Remarks

Columns are numbered starting at 1 and ascend in numerical sequential order. For recnum tables, the record number of the record can be addressed as (pseudo-) field 0.

 

This attribute is somewhat redundant, since you need to know the field number in order to retrieve the field number:

Integer i

Get_Attribute DF_Field_Number of Customer.File_Number 5 to i

Send Info_Box i

Most likely, what you want is to retrieve the number of a field if you already have its name. To do so, use the Field_Map command or Get_FieldNumber function..