run index maintenance error
Richard Kreiss
rkreiss at gccconsulting.net
Mon Apr 16 15:21:39 PDT 2007
I have a report using -v select processing.
When run using rreport I get an index maintenance on the index being used for the - lookup.
Run the same report using dreport, it runs perfectly.
The problem seems to be at line 11
Year(4,.0), syear and lyear are (4,.0,g). Index C is built on year
Lyear is "2099"
top ◄ If: expire_date = ""
Then: GOTO begin
9 ------- - - - - - - - - - - - - - - - -
◄ If: year lt syear 'select everything before syear
Then: GOSUB chk_mem 'then drop to next line
10 ------- - - - - - - - - - - - - - - - -
◄ If: year lt syear
Then: lookup - k=(syear) i=C -ng
11 ------- - - - - - - - - - - - - - - - -
is_done◄ If: year gt syear
Then: lookup - k=(lyear) i=C -nl
12 ------- - - - - - - - - - - - - - - - -
◄ If: is_done
Then: END
I have checked the data in the file and corrected any that might have created a problem.
Any suggestion as to what I may be looking for?
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list