Stuart have you tried SQL? Off the top of my head: SELECT DISTINCT CODE TO SLIST 0 FROM LOOKUP.TABLE WHERE @ID = "XYZ";
eg: (If you create the F7 dict entry for the VOC) 03 SELECT DISTINCT F7 TO SLIST 0 FROM VOC WHERE @ID = 'BASIC'; 4 record(s) selected to SELECT list #0. >>SAVE-LIST CLIST 4 record(s) SAVEd to SELECT list "CLIST". >EDIT-LIST CLIST 4 lines long. ----: P 0001: L 0002: P 0003: S 0004: X Bottom at line 4. ----: EX Craig Returns a select list containing Boydell, Stuart wrote:
I have a table which contains an MV list of codes. What I want to do is get a unique list of codes in the table for a lookup list... Table XYZ @ID = XYZ LINE = 1]2]3]4]5]6]7... CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB... The list I'd like returned is: AAA]BBB]CCC... The semantic I think I'd like is: SELECT LOOKUP.TABLE "XYZ" SAVING UNIQUE CODE However, this doesn't work. Is there a simple select statement to do this I'm overlooking? Cheers, Stuart ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
-- Craig Bennett Director Amajuba Pty Ltd Phone: 02 9987 0161 Mobile: 0412448781 Fax: 02 8456 5943 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
