Functions Reference

Chapter 4
|
Design functions 39
FieldIDs
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.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns a list of all field IDs in fileName and layoutName, 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.
If layoutName is empty, then the field IDs of the default table will be returned.
Examples
FieldIDs(“Customers”;””) returns IDs of all unique fields in the default table of
Customers.
FieldIDs(“Customers”;”Layout#5”) returns IDs of all unique fields, including
related fields, on Layout#5 in Customers.
FieldNames
Format
FieldNames(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.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text