On Fri, 20 Jan 2006 22:15:51 -0600, you wrote: >U2, > >WHAT IS THE EASIEST WAY TO MERGE THESE TWO SAVE.LIST'S - I NEED A UNION >PRESERVING THE KEYS (ALL EFFORTS HAVE GIVEN ME WORKING ELEMENTS FORM >EITHER SELECT1 OR SELECT2 - TOO TIRED TO THINK ANY MORE)? > >IF X.DATE.BEGIN NE "" AND X.DATE.END NE "" THEN > X.SELECT1 = "SELECT X " > X.SELECT1 := " WITH CHECK.DATE GE ": X.DATE.BEGIN :" AND ADVICE.DATE >LE ": X.DATE.END :" AND ADD.DATE GE ": X.DATE.BEGIN :" AND ADD.DATE LE >": X.DATE.END :"" > EXECUTE X.SELECT1 > EXECUTE "SAVE.LIST SL.LIST1" >END > >IF XL.VOIDED NE "" THEN > X.SELECT2 = "SELECT X " > X.SELECT2 := " WITH CHECK.NO EQ ": XL.VOIDED :" OR ADVICE.NO EQ ": >XL.VOIDED :"" > EXECUTE X.SELECT2 > EXECUTE "SAVE.LIST SL.LIST2" >END
EXECUTE "GET.LIST SL.LIST1 TO 1" EXECUTE "GET.LIST SL.LIST2 TO 2" EXECUTE "MERGE.LIST 1 UNION 2" Result will be active select list 0, (default), as a union of 1 and 2... HELP MERGE.LIST for options. Regards. -- Allen Egerton [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
