last update using get next from a different file

Kenneth Brody kenbrody at spamcop.net
Wed Sep 24 16:04:14 PDT 2014


On 9/24/2014 6:14 PM, Mike Fedkiw wrote:
[...]
>>> start  ◄ If:
>>>         Then: lookup invy  k=xx   i=E -ng
>> [...]
>>
>> Forget about the lookup entirely.  Go into dscreen on "invy", and add
>> "!@UD" to a screen.  Then go into dclerk directly to the "invy" file, and
>> scroll through the files.  What does @UD show?
>
> That's what I did and It shows different dates on pretty much every record

So, a lookup to "invy" shows one date for "invy(@UD)", but plaing "!@UD" on 
a screen in invy shows a different date?

Can you simplify the processing, and arrange to send files to fPTech to 
demonstrate?

BTW:

> getud  ◄ If:
>        Then: rn=invy(@rn)
> 104  -------   -   -   -   -   -   -   -   -
>        ◄ If:
>        Then: lookup invyud = invy  r=rn   -e
> 105  -------   -   -   -   -   -   -   -   -
>        ◄ If:
>        Then: ud=invyud(@ud)
> 106  -------   -   -   -   -   -   -   -   -
>        ◄ If:
>        Then: return
> 107  -------   -   -   -   -   -   -   -   -

This is pretty much a "useless use of a lookup", as the entire subroutine 
can be replaced with "ud=invy(@ud)".  (I am assuming that you tried this, 
assuming that there was something "wrong" with getnext here?)

-- 
Kenneth Brody


More information about the Filepro-list mailing list