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