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