RelationInfo()

 <  Day Day Up  >  

RelationInfo()

Category: Design

Syntax: RelationInfo ( fileName ; tableOccurance )

Parameters: fileName ”a string or text expression representing the name of an open file; tableOccurence ”a string or text expression representing the name of a particular table occurrence in fileName .

Description: Returns a list of information about all the table occurrences that are related to the specified tableOccurrence .

The results are formatted as

 

 FileName Related Table Reference::Related Field Local Related Field Options for "right" side of relationship ( "Delete", "Create" and/or "Sorted") 

Repeat above four lines for each relationship.

Examples:

 

 RelationInfo (Get(FileName);"Contacts 2") 

might return values that look like this:

 

 MyDatabase Invoice_Line::ContactID_fk ContactID_pk Delete Sorted MyDatabase Phone_Nums::ContactID_fk ContactID_pk Delete 

Comments:

The RelationInfo() function returns four lines for each table occurrence that's related to the one you specify. If there are no options selected on the "right" side of the relationship, the fourth line is blank.

Note that the first line tells you the name of the file where the base table resides, but does not tell you the name of the table occurrence itself. If multiple match criteria are defined for the relationship, only the first one is listed by the RelationInfo() function. Similarly, there is no indication about the join operator used.

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net