Ah... If that's what you want, then in BASIC
SELECTINDEX "STOCK.ID" FROM F.REPAIR Should have exactly the same effect (and save the overhead of an EXECUTE). The only difference is the resulting select list may not be sorted (although I think it is). If you then want to find what records are then associated with each stock id SELECTINDEX "STOCK.ID", STOCK.ID FROM F.REPAIR Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 14 March 2008 13:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes Thanks! This is by far the easiest, and it works! -----Original Message----- [EMAIL PROTECTED] wrote: At the universe tcl: SELECT REPAIR SAVING UNIQUE STOCK.ID ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/