A gotcha warning
GCC Consulting
gcc at optonline.net
Tue Mar 16 12:53:08 PST 2004
I set up to run a sales analysis report on the file orders using the system
command and @once processing from another file.
When I first test the processing, I received an index maintenance error on
orders index e (invoice #).
Rebuild the index and still received the error.
I tested the processing from the command line and it worked perfectly.
Since the input processing asks for several possible variables to select records
for this report, one of them being invoice #, I do a lookup to the orders file
to insure that the starting and ending invoice #'s are valid.
Here's the "GOTchA": you need to do a close on the orders file before running
the system command.
It's logical as the input process has the index open even if the process hasn't
gone to that sub-routine.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list