index problem

Kenneth Brody kenbrody at bestweb.net
Tue Nov 23 06:33:06 PST 2004


GCC Consulting wrote:
> 
> I have a program which has been running for over 2 years without a problem.
> Last week the program kicked up an index error.
> 
> The program runs from @once in a file called inquire.  The user enters an order
> # and the program checks file ls_850 to insure it is a valid order.  The index
> is index b and the error says run index maintenance.
> 
> I have deleted the lockfile & the index from the command prompt and then rebuilt
> the index.

Any reason you deleted the lockfile?  Did it say someone was in the file?
Are you certain that nobody was using it?

> I even changed the method of lookup and used index A - order number and still
> received the error.
> 
> I commented out lines 14 & 15, the lookup, and the report ran just fine.

Could the index be getting corrupted from somewhere else?  I notice that
this processing doesn't modify that file.

Does it always fail, or only on occasion?  On every order number, or only
some?

[...]
> 10do_recIf:
>   Then:lookup inq = inquire r=r -n
> 11 If:locked(inq)
>   Then:r=r+"1";GOTO do_rec

On a side note, line 11 will never be executed, as the lookup can never
fail due to the record being locked.

[...]

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody/at\spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+
Don't e-mail me at: <mailto:ThisIsASpamTrap at gmail.com>



More information about the Filepro-list mailing list