Article

How to specify multiple field pairs in a Prodataset DATA-RELATION?

« Go Back

Information

 
EnvironmentAll Supported Operating Systems
OpenEdge 10.x
Question/Problem Description

How to specify multiple field pairs in a ProDataSet DATA-RELATION?


What is the syntax for relating a parent and a child tables of a DATASET with multiple fields?
How to specify multiple pairs in the RELATION-FIELDS attribute of a DATA-RELATION?
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
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)
Workaround
Notes
Attachment 
Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful.



Characters Remaining: 255

 



Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved.
Previous MonthNext Month
SunMonTueWedThuFriSat