Returns a list of all field IDs in fileName and layoutName.


FieldIDs ( fileName ; layoutName )


fileName - the name of an open database file (local or remote).

layoutName - the name of a layout or table in the specified database file.

Data type returned 


Originated in version 

6.0 or earlier


Listed items are separated by carriage returns.

Related fields are returned as TableID::RelatedFieldID.

For example, 12::4, where 12 is the ID of the table and 4 is the ID of the related field.

Example 1 

FieldIDs ( "Customers" ; "" ) returns IDs of all unique fields in the default table of Customers.

Example 2 

FieldIDs ( "Customers" ; "Layout#5" ) returns IDs of all unique fields, including related fields, on Layout#5 in Customers.