Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
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
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
(local or remote).
layoutName - the name of a
in the specified database file.
Important
See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text
Description
IDs in fileName and layoutName, separated by carriage
returns.
TableID::RelatedFieldID
.
For example,
12::4
, where
12
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)