Wouldn't it be simpler to... 1. Maintain an attribute in dict ORD.HDR that contains all of the related ORD.DTL ids (or an I-type that builds such a list), perhaps called ORD.DTL.IDS
2. SELECT ORD.HDR WITH CUST.NAME EQ "ABC" "XYZ" ORD.DTL.IDS Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Thursday, November 04, 2004 12:44 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Index problem [snip] Then 2 steps at TCL or pararaph: >SELECT ORD.HDR WITH CUST.NAME = "XYZ" "ABC" etc... >>XSELECT ORD.DTL HDR.ID XSELECT takes an active select list of ORD.HDR IDs and essentially does: DTL.LIST = '' LOOP WHILE READNEXT HDR.ID FROM 0 SELECTINDEX 'HDR.ID', HDR.ID FROM DTL.FVAR TO 10 READLIST TEMP.LIST FROM 10 DTL.LIST<-1> = TEMP.LIST REPEAT FORMLIST DTL.LIST TO 0 STOP ending with an active select list of all ORD.DTL ids that have CUST.NAME resolved to "XYZ" or "ABC". It is fast. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
