Functions Reference

Chapter 4
|
Design functions 45
Description
Returns the specified field’s comment. The field name must be in the form
tablename::fieldname to specify a field that exists in a table different from the current
table.
Examples
FieldComment("Customers"; "Phone Number") returns “Customer's home
telephone number” if it was entered as a comment for the Phone Number field.
FieldComment("Customers"; "Accounts::Current Balance") returns
“Customer's current balance” if it was entered as a comment for the Current Balance
field in the Accounts table.
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” on page 41 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)