:) Thanks all -----Original Message----- From: Wols Lists Sent: Saturday, 28 May 2011 1:34 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Emulate SQL MAX() function at TCL
On 27/05/11 14:33, Charles Stevenson wrote: > I am going to assume we are talking about a HUGE file, otherwise > efficiency wouldn't much matter. > > I don't know a GOOD way outside basic or sql to prevent a sort-selected > list from being created. For humongous files, that may be painful. Hmmm... Assuming a huge file, as you suggest, create an index on @ID! Indexes are always sorted, aren't they? So either make it sort downwards or, if it's numeric, index on "nought minus id" :-) Then you can just SELECTINDEX READNEXT CLEARLIST All done! Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
