Filemaker TH325Z/A Ficha de datos descargar pdf (Pagina 45)

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)

1 2 ... 40 41 42 43 44 45 46 47 48 49 50 ... 237 238

Sin comentarios

Filemaker TH325Z/A Ficha de datos Pagina 45