Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Design functions > FieldNames function |
|
|
| FieldNames function |
| 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 for information about literal text parameters. |
| Data type returned |
| text |
| Description |
| Returns a list of the names of all fields on layoutName, in fileName file, separated by carriage returns. Related fields are displayed in tablename::fieldname format. |
| If layoutName isn't specified, then the field names of the first table created (the "default table") will be returned. |
| Examples |
| FieldNames("Customers";"") returns a list of all the fields in the default table of the Customers database file. |
| FieldNames("Customers";"Data Entry") returns a list of all the fields, including related fields, in the Customers database file that appear on the Data Entry layout. |
| 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 > FieldNames function |
|
|
Next Page |
|