-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
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
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
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]
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
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
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
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&
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
: 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
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
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
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
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
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
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
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
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
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
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
20 matches
Mail list logo