Kbase P185733: How to specify multiple field pairs in a Prodataset DATA-RELATION?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/04/2011 |
|
Status: Unverified
GOAL:
How to specify multiple field pairs in a ProDataSet DATA-RELATION?
GOAL:
What is the syntax for relating a parent and a child tables of a DATASET with multiple fields?
GOAL:
How to specify multiple pairs in the RELATION-FIELDS attribute of a DATA-RELATION?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
OpenEdge Language Category: ProDataSets
FIX:
The syntax of defining a DATASET with a DATA-RELATION that has multiple pairs of RELATION-FIELDS is:
DEFINE DATASET DataSetName FOR Parent, Child
DATA-RELATION DataRelationName FOR Parent, Child
RELATION-FIELDS (parent-field1, child-field1, parent-field2, child-field2,. . ., parent-fieldn, child-fieldn)
For example:
DEFINE DATASET DataSetName FOR Parent, Child
DATA-RELATION DataRelationName FOR Parent, Child
RELATION-FIELDS (parent-field1, child-field1, parent-field2, child-field2, parent-field3, child-field3)