Filemaker TH325Z/A Fiche technique télécharger pdf (Page 51)

Chapter 4

Design functions 51

Example

LayoutObjectNames ("Customers";"Data Entry") returns a list of named

objects in the Customers database file that appear on the Data Entry layout.

RelationInfo

Format

RelationInfo(fileName;tableName)

Parameters

fileName - the name of an open database file (local or remote).

tableName - the name of a table in the specified database file.

Important See FileMaker Pro Help for information about literal text parameters.

Data type returned

text

Description

Returns a list of four values for each relationship directly related to tableName. Values

in a list are separated by carriage returns, and lists are separated by two carriage returns.

For each additional relationship connected to tableName, an additional list of four values

is output.

The four values are:

• Source: the name of the database file that holds tableName

• Table: the name of the table connected to tableName

• Options: the options that were set in the right side of the Edit Relationship dialog

box when the relationship was defined. This line is blank if the following options are

not set; otherwise these options are separated by spaces.

• Delete, if Delete related records in this table when a record is deleted in the

other table is selected in the right side of the Edit Relationship dialog box

• Create, if Allow creation of records in this table via this relationship is

selected in the right side of the Edit Relationship dialog box

• Sorted, if Sort records is selected in the right side of the Edit Relationship dialog

box

• Relationships: a list of the defined relationships, one per line. Field names are

fully qualified, for example, TableName::Field Name.

1 2 ... 46 47 48 49 50 51 52 53 54 55 56 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 51