Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Design functions > FieldIDs function |
|
|
| FieldIDs function |
| 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 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. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Design functions > FieldIDs function |
|
|
Next Page |
|