LOCATE statement on AP and R83 
Author Message
 LOCATE statement on AP and R83

Rather than BY "AR", use BY "ARS", which was added just for this
reason.  Depending on the AP 6.something that you have, this will work
fine.  If if doesn't, then you need a patch or an upgrade.  I just
tried it on 7.1 and all is well.  See
http://www.***.com/
available for AP 6.something.  :)

Tony


Quote:
>Is it me ... or what?  I'm using AP 6.something

>Can anyone tell me why the loop:

>    LOCATE VAL IN LIST BY 'AR' SETTING POSN ELSE
>            INS VAL BEFORE LIST<POSN>
>    END

>produces a LIST containing:

>    1^2^3^4^5^6^7^8^9^10^20^1.1^100^2.2^200^9.9

>when I add these data values?

>The same happens when the insert is performed by:

>    LIST=INSERT(LIST,POSN;VAL)

>I just found the same happens with R83

>Cas


http://www.***.com/
(Restructured/Updated 17-Aug-1998)
Pick Systems Quality Assurance Manager
http://www.***.com/
## Insert disclaimer here about how these comments
## are mine and not my employer's.
## Oh, I did?
## Never mind.


Wed, 14 Feb 2001 03:00:00 GMT
 LOCATE statement on AP and R83

This is exactly the way it's supposed to work.  The 'AR' codes does NOT
say use numeric compares, but only to right justify the comparisons.  So
1.1 IS > space 20.  If you "normalized" these fields with spaces, they
would sort this way.

The new "ARS" and "DRS" codes were added to make the sorts use numeric
compares.

Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc.  USA



Wed, 14 Feb 2001 03:00:00 GMT
 LOCATE statement on AP and R83


Quote:
>This is exactly the way it's supposed to work.  The 'AR' codes does NOT
>say use numeric compares, but only to right justify the comparisons.  So
>1.1 IS > space 20.  If you "normalized" these fields with spaces, they
>would sort this way.

>The new "ARS" and "DRS" codes were added to make the sorts use numeric
>compares.

>Mark Brown
>Manager, Continuing Engineering
>Pick Systems, Inc.  USA

If I ever doubted the value of cdp (which I didn't), all doubts are now
GFE (gone for ever)!!!

I always new about the right justification compare not coping with
numeric values (and negative values) so have always performed some pre-
processing on the figures before doing a locate where numeric/dates are
to be sorted (add a large constant and multiply to ensure the variable
was a positive integer).  But this 'ARS' and 'DRS' job make that
unnecessary - all that confusing code I can now get rid of!!

Only two questions:-
1. Why is this excellent feature not documented in the AP manual?

2. When was it introduced? - Our earliest AP client is on 6.1.15.PRO113
will it work for them ?

Thanks...
----------------------------------------------------------------------
John Lewis                        +   Telephone: +44 (0)1285 861874
Cerney Computer Services Ltd.     +   Fax:       +44 (0)1285 862688

----------------------------------------------------------------------



Fri, 16 Feb 2001 03:00:00 GMT
 LOCATE statement on AP and R83
On Mon, 31 Aug 1998 10:14:08 +0100, John Lewis

Quote:

>If I ever doubted the value of cdp (which I didn't), all doubts are now
>GFE (gone for ever)!!!

>Only two questions:-
>1. Why is this excellent feature not documented in the AP manual?

From the documentation that I see, it looks like this was intended
only as a 'transition feature' because there are lots of old
references to which versions it will or will not run on.  That doesn't
make much sense though.  It appears to be here to stay, since it's
been around for 3 major releases now.  It should be in the next
Reference Manual, minus all of the old references aforementioned.

Quote:

>2. When was it introduced? - Our earliest AP client is on 6.1.15.PRO113
>will it work for them ?

Best way to find out is to test it using a little bit of code that
sorts with the AR, then does the same thing with ARS.  Pro 6.1.15
might be borderline.

Regards,
Tony

http://members.home.net/gravagno
(Restructured/Updated 26-Aug-1998)
Pick Systems Quality Assurance Manager
http://www.picksys.com
## Insert disclaimer here about how these comments
## are mine and not my employer's.
## Oh, I did?
## Never mind.



Sat, 17 Feb 2001 03:00:00 GMT
 LOCATE statement on AP and R83

writes
[snip]
Quote:
>>2. When was it introduced? - Our earliest AP client is on 6.1.15.PRO113
>>will it work for them ?

>Best way to find out is to test it using a little bit of code that
>sorts with the AR, then does the same thing with ARS.  Pro 6.1.15
>might be borderline.

[snip]

Thanks Tony,

I have tried it on our system which was originally 6.1.15.PRO113 but we
have loaded the M78 patch (which appears to take us to 6.1.25.PRO146).
I don't particularly want to go to the site of our 'earliest' client
(400 mile round trip) just to test this feature!!

I know - I'll load the M78 patch next time I'm there..........

No problem!!
----------------------------------------------------------------------
John Lewis                        +   Telephone: +44 (0)1285 861874
Cerney Computer Services Ltd.     +   Fax:       +44 (0)1285 862688

----------------------------------------------------------------------



Sat, 17 Feb 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. If you need some monolith bord for Pick R83, Ap natif or Ap pro

2. AP/R83 Native -> D3 ProPlus migration trouble

3. problem with t-load to R83 from AP

4. R83 to AP/DOS or D3/NT

5. ? supress tape label on R83/AP SAVE

6. r83 to ap upgrade & new disk drive

7. r83 to ap/pro upgrade

8. porting ap/r83 to d3 linux

9. AP to R83

10. File documentation in R83 vs AP/DOS

11. converting old ADDS to R83 to AP

12. Need AP/DOS - R83 3.1M


 
Powered by phpBB® Forum Software