Try SSELECT fname Sample 2
> -----Original Message----- > From: George Gallen [SMTP:[EMAIL PROTECTED] > Sent: Thursday, May 25, 2006 2:19 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OK...Is there a way....UV > > ok. but I would be using this from TCL, a paragraph. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill > > Sent: Thursday, May 25, 2006 5:17 PM > > To: 'u2-users@listserver.u2ug.org' > > Subject: RE: [U2] OK...Is there a way....UV > > > > > > 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/ > ------- > 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/