That the Select List returned from SELECTINDEX is sorted is only an artifact resulting from the fact that keys are stored in sorted order in a B-tree index.
Don't forget that you can send the result to any Select List (not just the default one) and, if desired/necessary, convert it to a dynamic array using READLIST which can be converted back to a Select List any number of times, or saved using the SAVELIST statement. That's a whole lot more EXECUTEs you can save. Note that SAVELIST requires a dynamic array, not a Select List, which is somewhat counter-intuitive. > ----- Original Message ----- > From: "Anthony Youngman" <[EMAIL PROTECTED]> > To: "'u2-users@listserver.u2ug.org'" <u2-users@listserver.u2ug.org> > Subject: RE: [U2] Indexes > Date: Fri, 14 Mar 2008 17:53:27 +0000 > > > 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 > <snip> ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/