I have found that U2 works the fastest in UniBasic via
clearselect ALL
execute "SELECT FILE BY @ID"
loop...
read R.Item from F.FILE, This.Item
This.Item = R.Item<23>
begin case
case This.Item = My.Item ; null
case 1 ; go Next.Item
end case
My.Array<-1> = This.Sample
Next.Item:
next
--Bill
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Thursday, May 25, 2006 3:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OK...Is there a way....UV
I want to sort a file by @ID and only take the first two items...
SELECT FILE BY @ID SAMPLE 2
doesn't work, it first takes the sample of 2, then sorts it.
SELECT FILE BY @ID
SELECT FILE SAMPLE 2
works, but takes two lines
How can I phrase my SELECT so it will sort first, then sample later, instead
of sample first, sort later?
I'm running UV.
George
George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220
SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.com
-------
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/
