last update using get next from a different file

[Mike Fedkiw]

Well now I think I see what's going on, maybe. If I look at the first 
record in the report the @UD date on that record is 09/15/14 and so is 
every other date for the 20k records within the report.

But this I don't understand at all, I tried to do a gosub lookup using 
the record number to get the @ud of that record and it still fills in 
the 09/15/14 date on everything. I'll put a couple pieces of the code 
below so you can see what I'm doing. I used the invy(@rn) because that 
seems to work perfectly fine, now I am really lost.

start  ◄ If:
        Then: lookup invy  k=xx   i=E -ng
   3  -------   -   -   -   -   -   -   -   -   -   -   -
nextin ◄ If:
        Then: kn="";wa="";dp="";cl="";dd="";cd="";vi=""
   4  -------   -   -   -   -   -   -   -   -   -   -   -
        ◄ If: not invy
        Then: close invy;delete;close;exit
   5  -------   -   -   -   -   -   -   -   -   -   -   -
        ◄ If:
        Then: cc=cc+"1"
   6  -------   -   -   -   -   -   -   -   -   -   -   -
        ◄ If:
        Then: showctr("12") "INVY - Records Processed"<cc
  7  -------   -   -   -   -   -   -   -   -
       ◄ If:
       Then: display
  8  -------   -   -   -   -   -   -   -   -
       ◄ If: invy(118) eq "y"
       Then: getnext invy;goto nextin
  9  -------   -   -   -   -   -   -   -   -
       ◄ If: invy(77) eq "y"
       Then: getnext invy;goto nextin
10  -------   -   -   -   -   -   -   -   -
       ◄ If: 'invy(4) eq "aaa"
       Then: 'getnext invy;goto nextin
11  -------   -   -   -   -   -   -   -   -
       ◄ If: invy(47) eq ""
       Then: getnext invy;goto nextin
12  -------   -   -   -   -   -   -   -   -
       ◄ If:
Then: ud="";gosub getud

etc...etc...

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


doexp  ◄ If:
        Then: export multi invfile=c:\export\invyfile.slk
  42  -------   -   -   -   -   -   -   -   -   -   -   -   -
        ◄ If: ot eq ""
        Then: gosub once;ot(1,*,g)="y";goto start
  43  -------   -   -   -   -   -   -   -   -   -   -   -   -
        ◄ If:
        Then: invfile(1)=invy(3)
  44  -------   -   -   -   -   -   -   -   -   -   -   -   -
        ◄ If:
        Then: invfile(2)=invy(4)
  45  -------   -   -   -   -   -   -   -   -   -   -   -   -
        ◄ If:
        Then: invfile(3)=kn


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

67  -------   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: invfile(25)=invy(36)
68  -------   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: invfile(26)=oh
69  -------   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: invfile(27)=invy(@rn)
70  -------   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: invfile(28)=ud <<no matter what I do here the date is 
09/15/14, the date of the first record found
71  -------   -   -   -   -   -   -   -   - -
       ◄ If:
       Then: invfile(29)=hl
72  -------   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: getnext invy;goto nextin

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

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  -------   -   -   -   -   -   -   -   -

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




Mike



On 9/24/2014 5:04 PM, Kenneth Brody wrote:
> On 9/24/2014 4:02 PM, Mike Fedkiw via Filepro-list wrote:
>> I'm resending this because I think I only replied to Ken last time.
>>
>> Okay I get what invy(@ud) is but since it returns the exact same date 
>> for
>> like 20+ thousand records and that's just impossible in my system, I'm
>> wondering how it handles a getnext command. Could it always be reporting
>> the date from the initial record of the lookup and not getting the 
>> @ud of
>> records obtained with a getnext or getprev command.
> [...]
>
> No, "lookupname(@UD)" returns the update date for the *current* record 
> in the lookup file.  Add "!@UD" to a screen in the other file, and 
> browse it in dclerk.  See what it shows.
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20140924/2eb2493d/attachment.html>