Filemaker TH325Z/A Arkusz Danych Pobierz pdf (Strona 52)

52 FileMaker Functions Reference

Example

A database file called Human Resources has three tables: Company, Employees, and

Addresses. Company::Company ID is connected to Employees::Company ID,

Employees::Employee ID is connected to Addresses::Employee ID and

Employees::DateOfHire is connected to Addresses::DateMovedIn.

The relationships have the following criteria:

• You can create records in all tables.

• You cannot delete records in all tables.

• A sort was specified for the Addresses table for the Employees<-->Addresses

relationship.

RelationInfo(“Human Resources”;“Employees”) returns:

Source: Human Resources

Table: Company

Options: Create

Company::Company ID = Employees::Company ID

Source: Human Resources

Table: Addresses

Options: Create Sorted

Addresses::Employee ID = Employees::Employee ID

Addresses::DateMovedIn >= Employees::DateOfHire

ScriptIDs

Format

ScriptIDs(fileName)

Parameter

fileName - the name of an open database file

(local or remote).

Important See “Design functions” on page 41 for information about literal text parameters.

Data type returned

text

Description

Returns a list of all script IDs in fileName, separated by carriage returns.

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

Brak uwag

Filemaker TH325Z/A Arkusz Danych Strona 52