The FieldNumber script function returns the number of a specified field within a previously loaded table. If the function is used within a LOAD statement, it must not reference the table currently being loaded.
Syntax:
FieldNumber(field_name ,table_name)
Arguments:
| Argument | Description |
|---|---|
| field_name | The name of the field. |
| table_name | The name of the table containing the field. |
If the field field_name does not exist in table_name, or table_name does not exist, the function returns 0.
Example:
LET a = FieldNumber('Customer','tab1');