using openedge version 11.2 & progress developer studio.
i'm using several temp-table definitions (each in separate include file) form dataset. looks ok if use 1 pair relation-fields single data relation. add relation-fields pair definition , drop include file on form (or import schema via "import schema file" button) dataset shows duplicate child table no columns. simplicity sake , testing, i've set 3 test files :
tt1.i - first temp-table:
/* temp table 1 */ define temp-table tt1 field tt_test character field tt_rel_field_1 integer field tt_rel_field_2 integer index tt_idx tt_rel_field_1 tt_rel_field_2. tt2.i - second temp-table:
/* temp table 2 */ define temp-table tt2 field tt_test2 character field tt_rel_field_1 integer field tt_rel_field_2 integer index tt_idx tt_rel_field_1 tt_rel_field_2. dstest.i - dataset definition:
/* dataset definition */ {tt1.i} {tt2.i} define dataset dstest tt1 , tt2 data-relation drtest tt1 , tt2 relation-fields ( tt_rel_field_1,tt_rel_field_1, tt_rel_field_2,tt_rel_field_2 ). printscreen of happens when drop dstest.i on form :
if remove second pair, works fine - gui wise. missing obvious here ? examples i've found far use single relation-pair. wonder why. according progress knowledgebase article 000018088 there no voodoo involved.
your syntax looks correct according manuals. interesting thing not see place in our whole environment ever use more 1 relation-field. may wants create relationship each field defined.
what data place in tables? data must form unique match.
i ask tom bascom input on this. https://stackoverflow.com/users/123238/tom-bascom
=============
page 1-19 of openedge development: prodatasets manual following:
define dataset dsorder ttorder, ttoline, ttitem data-relation orderline ttorder, ttoline relation-fields (ordernum, ordernum) data-relation lineitem ttoline, ttitem relation-fields (itemnum, itemnum). sorry not sure how formatting here, maybe test creating table link between two?
Comments
Post a Comment