Error when deleting the last record out of a file

Mike Schwartz mschw at athenet.net
Thu Dec 20 19:55:22 PST 2007


> As to why the lookup failed - how many reasons can
> there be?  I can think of 3:
> #1 Record is not in the index lookup.
> #2 Disk is full on a free lookup.
> #3 you used the -w flag and the record is locked
> 
> Filepro provides the locked() function for the last
> instance.
> 
> Jeff Harrison

     I think reason #1 applies here.  It wasn't that I attempted to read
past the end of the data file by using the -b option on the lookup, but
rather that I attempted to read past the end of the index with a getnext.
The error was:

/u/filepro/storesort/indexabc.A: invalid argument

     There were 10,000 pre-allocated blank records in the file.  It is used
as a temporary place to hold things like subtotals for multi-company
reports. Generally only a few subtotal records are in this file at any one
time.  On cross-company subtotals for customers, the file may hold 6,000 or
7,000 records.  I don't ever recall this file exceeding the 10,000
pre-allocated records, so doubt that I was trying to read past the 10,000th
record.

     I'm still surprised that the -b option gave me this index error,
though.  I'm sure I've used -b before in situations like this, so I have a
couple of hundred applications written over the past 30 years or so that I
better go back through and check.  Or, maybe I just have to check the lookup
that use the "get next greater record" function on the initial lookup line.


Mike Schwartz




More information about the Filepro-list mailing list