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.
Commentaires sur ces manuels