FieldIDs

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

Format 

FieldIDs ( fileName ; layoutName )

Parameters 

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 

text

Originated in version 

6.0 or earlier

Description 

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.