run index maintenance error

Jeff Harrison jeffaharrison at yahoo.com
Mon Apr 16 19:47:53 PDT 2007


--- Richard Kreiss <rkreiss at gccconsulting.net> wrote:

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

Hi Richard.  What is the exact error message that you
are getting?  I don't think it really is "Index
Maintenance".  When you get different results with
rreport and dreport the first thing to check is that
you have tokenized all of the tables that could be
used.  Especially the output processing table, -v
table, and automatic processing table.

Also, have you re-built index C?  

Good Luck.

Jeff Harrison

jeffaharrison at yahoo.com

Author of JHImport and JHExport. The fastest and
easiest ways to import and export with filepro. 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the Filepro-list mailing list