<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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. <br>
<br>
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. <br>
<div class="moz-cite-prefix"><br>
start ◄ If:<br>
Then: lookup invy k=xx i=E -ng<br>
3 ------- - - - - - - - - - - -<br>
nextin ◄ If:<br>
Then: kn="";wa="";dp="";cl="";dd="";cd="";vi=""<br>
4 ------- - - - - - - - - - - -<br>
◄ If: not invy<br>
Then: close invy;delete;close;exit<br>
5 ------- - - - - - - - - - - -<br>
◄ If:<br>
Then: cc=cc+"1"<br>
6 ------- - - - - - - - - - - -<br>
◄ If:<br>
Then: showctr("12") "INVY - Records Processed"<cc<br>
7 ------- - - - - - - - -<br>
◄ If:<br>
Then: display<br>
8 ------- - - - - - - - -<br>
◄ If: invy(118) eq "y"<br>
Then: getnext invy;goto nextin<br>
9 ------- - - - - - - - -<br>
◄ If: invy(77) eq "y"<br>
Then: getnext invy;goto nextin<br>
10 ------- - - - - - - - -<br>
◄ If: 'invy(4) eq "aaa"<br>
Then: 'getnext invy;goto nextin<br>
11 ------- - - - - - - - -<br>
◄ If: invy(47) eq ""<br>
Then: getnext invy;goto nextin<br>
12 ------- - - - - - - - -<br>
◄ If:<br>
<font color="#cc0000">Then: ud="";gosub getud</font><br>
<br>
etc...etc...<br>
<br>
-------------------------------------------------------------------------------------------------<br>
<br>
<br>
doexp ◄ If:<br>
Then: export multi invfile=c:\export\invyfile.slk<br>
42 ------- - - - - - - - - - - - -<br>
◄ If: ot eq ""<br>
Then: gosub once;ot(1,*,g)="y";goto start<br>
43 ------- - - - - - - - - - - - -<br>
◄ If:<br>
Then: invfile(1)=invy(3)<br>
44 ------- - - - - - - - - - - - -<br>
◄ If:<br>
Then: invfile(2)=invy(4)<br>
45 ------- - - - - - - - - - - - -<br>
◄ If:<br>
Then: invfile(3)=kn<br>
<br>
<br>
-------------------------------------------------------------------------------------------------------<br>
<br>
67 ------- - - - - - - - - -<br>
◄ If:<br>
Then: invfile(25)=invy(36)<br>
68 ------- - - - - - - - - -<br>
◄ If:<br>
Then: invfile(26)=oh<br>
69 ------- - - - - - - - - -<br>
◄ If:<br>
Then: invfile(27)=invy(@rn)<br>
70 ------- - - - - - - - - -<br>
◄ If:<br>
Then: invfile(28)=ud <font color="#cc0000"><<no
matter what I do here the date is 09/15/14, the date of the
first record found </font><br>
71 ------- - - - - - - - -
- <br>
◄ If:<br>
Then: invfile(29)=hl<br>
72 ------- - - - - - - - - -<br>
◄ If:<br>
Then: getnext invy;goto nextin<br>
<br>
---------------------------------------------------------------------------------------------------------<br>
<br>
<font color="#cc0000">getud</font> ◄ If:<br>
Then: rn=invy(@rn)<br>
104 ------- - - - - - - - -<br>
◄ If:<br>
Then: lookup invyud = invy r=rn -e<br>
105 ------- - - - - - - - -<br>
◄ If:<br>
Then: ud=invyud(@ud)<br>
106 ------- - - - - - - - -<br>
◄ If:<br>
Then: return<br>
107 ------- - - - - - - - -<br>
<br>
------------------------------------------------------------------------------------------------------------<br>
<br>
<br>
<br>
<br>
Mike<br>
<br>
<br>
<br>
On 9/24/2014 5:04 PM, Kenneth Brody wrote:<br>
</div>
<blockquote cite="mid:542331DE.4000202@spamcop.net" type="cite">On
9/24/2014 4:02 PM, Mike Fedkiw via Filepro-list wrote:
<br>
<blockquote type="cite">I'm resending this because I think I only
replied to Ken last time.
<br>
<br>
Okay I get what invy(@ud) is but since it returns the exact same
date for
<br>
like 20+ thousand records and that's just impossible in my
system, I'm
<br>
wondering how it handles a getnext command. Could it always be
reporting
<br>
the date from the initial record of the lookup and not getting
the @ud of
<br>
records obtained with a getnext or getprev command.
<br>
</blockquote>
[...]
<br>
<br>
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.
<br>
<br>
</blockquote>
<br>
</body>
</html>