Re: HELP syntax of composites<.....>?

}From: kistler@an.hp.com (Jim Kistler) }Date: 28 Apr 1995 20:34:08 GMT }X-Informix-List-Id: <news.13463> } } !!!!!------I'm using ISQL------not 4GL!!!!! } }I have two pairs of data entries on a form and I want each pair of }entries to match one of many pairs of entries in a REFERENCE table. }The "composites" syntax is not clear enough to see how to match MULTIPLE }pairs of fields to the same pair of columns in the REFERENCE table. } }My first "pair" of entries works fine...... } } field_1 = table_A.column_1 = table_R.reference_1; } field_2 = table_A.column_2 = table_R.reference_2; } } composites <table_A.column_1, table_A.column_2> } *<table_R.reference_1, table_R.reference_2> } }When I try to enter field_1 and field_2 values that don't match any of the }several pairs in column_1-column_2 of the REFERENCE table, table_R, the }form correctly objects. } }How can I repeat this for a second pair of fields in this form? } } field_3 = table_A.column_3 = table_R.reference_1; } field_4 = table_A.column_4 = table_R.reference_2; } } composites <???????????????> .......etc....... } }The compiler objects by saying [for both reference_1 and reference_2]: } }# The column "reference_1" name appears more than once. If you }# wish a column to be duplicated in a form, use the same display field label. }# See error number -2892. }... }Is this a limit of the "composites" capabilities? Yes, I think it is. You cannot encode (directly) two distinct composite joins from Table_A to Table_R. You could try creating a synonym for Table_R and using that for the second table, but you then run foul of bug B19471 "-2857 TRYING TO USE MORE THAN ONE VERIFY COMPOSITE JOIN IN FORM". This has been fixed in the next release (4.14/6.02), but isn't generally available yet. You could manage if LOOKUP supported composite fields, but it doesn't. I think you'd be best off moving to I4GL for this. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>