RE: HELP syntax of composites<.....>?
I had the same need in a system some time ago. To work around this problem I simply created views of my reference table and then used the view names. Chuck Francis PCP Member AT&T Normal Disclaimers ---------- From: ilist To: internet!rmy.emory.edu!informix-list Subject: HELP syntax of composites<.....>? Date: Friday, April 28, 1995 8:34PM !!!!!------I'm using ISQL------not 4GL!!!!! Maybe this isn't possible, but .....? 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: # # 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. and: # # The column "reference_2" 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. I have tried individual and composite indices without success. Is this a limit of the "composites" capabilities? Thanks, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ## ####### ## ## Jim Kistler ## ## ## ## kistler@hp-and.an.hp.com ## ## ## ## Hewlett-Packard Co. ## ##### #### Imaging Systems ## ## ## ## ## 3000 Minuteman Road ## ## ## ## ## Andover, MA 01810 ######## ## ## ## TEL: 508-659-2251 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~FAX: 508-687-7265~~~~~~~~~~