}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>