lookup error

Dennis DIller dendil at electricalusa.com
Tue Feb 8 11:57:04 PST 2011


I'm trying to add up some data and put the data in the proper month and year
from a check book file while sitting in the vendor file asking for the two 
digit year
Year   10   for 2010
the check file has a vendor id field(4)
and a field month & year it was written example 0210 for Feb. 2010 Field 
(14)
I have a auto index K with field 2 & 14 on this file
a dummy field tl that holds the vendor ID and month/year example  tl = 
BEV0210
Why do I get a error message on line 687 look up has not been performed
anyone help will be greatly appreciated
Denny

ytdloop *              If:      tj ge tk        'if tj get to 1310 return 13 
month 10th year
                        Then:      tj="01"{tf; tj=tj-"1"; tl=ti{tj; 
tk=tj+"1200"; 44=sa; sa=""; zz="1" ; return
                              If:
                          Then:     lookup ytd = decheck  k=tl   i=k -nx
 YTDLOP2    687  If:      not ytd or tj ne ytd(14)  'this add 100 to go to 
the next month 0110 +100=0210
                        Then:      tl=""; tj=tj+"100"; tl=ti{tj; zz=zz+"1"; 
close ytd; goto ytdloop
                          ■ If:     ytd and tj=ytd(14)    'this add the data 
put it the proper month
                         Then:     ttt[zz]=ttt[zz]+ytd(7); sa=sa+ytd(7); 
display; getnext ytd; goto ytdlop2
This work until there is a month with no entry example
bev0110            3,000   month1
bev0210            7,000   month2
bev0310            5,000   month3
bev0410             Look up is looking for bev0410 that record does not 
exist line 687 should be false  to goto bev0510

anyone have any input on this
Denny

 



More information about the Filepro-list mailing list