Re: [U2] OK...Is there a way....UV

2006-05-26 Thread Roger Glenfield
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Friday, May 26, 2006 10:18 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV hmm. there's a new one. Yes, that did work. Thanks George -Original Mes

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread George Gallen
all it REC.COUNT > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of George Gallen > Sent: Friday, May 26, 2006 10:18 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OK...Is there a wayUV > > > hmm. there&#

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread George Gallen
IL PROTECTED] Behalf Of Brian Leach > Sent: Friday, May 26, 2006 9:48 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OK...Is there a wayUV > > > George > > Hmmm, how are your IDs ordered? > > Just wondering whether something along these lines mig

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread George Gallen
hmm. there's a new one. Yes, that did work. Thanks George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, May 25, 2006 9:03 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread Brian Leach
George Hmmm, how are your IDs ordered? Just wondering whether something along these lines might work... SELECT ID TO SLIST 0 FROM YourFile WHERE ID <= (SELECT MIN(ID)+1 FROM YourFile) ORDER BY ID; Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On B

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread Brad Davis
riday, May 26, 2006 8:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a way....UV It is true that the sample is the first execution before the sorting takes place. Oracle DB dose the same thing. I was unsuccessfully trying to use sub-query in this case. Kathy -Ori

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread George Gallen
NOPE. Same thing. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina > Sent: Friday, May 26, 2006 8:25 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OK...Is there a wayUV > > > What about SSELEC

Re: [U2] OK...Is there a way....UV

2006-05-26 Thread Roger Glenfield
EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a way....UV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT < "2&

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread Nick Cipollina
What about SSELECT FILE FIRST 2? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread Vance, Kathy
: Thursday, May 25, 2006 6:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Played around a bit and figured out that SSELECT adds "BY @ID" to the end of the select attributes, hence SSELECT FILE BY @ID is redundant. SSELECT FILE BY F2 is equivalent to SELECT FIL

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Stuart . Boydell
ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT < "2" N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Geo

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Bob Woodward
processing, thereby forcing multiple lines in George's paragraph. Sorry George. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davis Sent: Thursday, May 25, 2006 2:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a way

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread GarryS
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 wayUV > > ok. but I would be using this

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Brad Davis
Use two statements: 1>SSELECT FILE BY @ID 2>SELECT FILE SAMPLE 2 Or 1>SELECT FILE SAMPLE 2 2>SSELECT FILE BY @ID -Original Message- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread George Gallen
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 ther

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Brutzman, Bill
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

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Jerry Banker
If you have an index on the file the index is already sorted so all you have to do is use the index when you select. The only criteria would be that the index is on the key or a field that will include all of the records or NO.NULLS is off. Example: SELECT CUST.MSTR BY CLIENT.6 SAMPLE 2 Will give

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread George Gallen
Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward > Sent: Thursday, May 25, 2006 4:13 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OK...Is there a wayUV > > > Oops. You want a SELECT... Try SSELECT FILE SAMPLE 2. > &g

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Bob Woodward
Oops. You want a SELECT... Try SSELECT FILE SAMPLE 2. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a f

RE: [U2] OK...Is there a way....UV

2006-05-25 Thread Bob Woodward
Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only