Error when deleting the last record out of a file

Mike Schwartz mike.appleton.wi at sbcglobal.net
Fri Dec 14 07:25:37 PST 2007


> Consider what the "-n" and "-b" flags mean.
> 
> The "-n" flag says that filePro should "do nothing", and allow you to
> test
> "not lookupname" for failure.
> 
> On the other hand, "-b" means "if the lookup fails, pretend it
> succeeded,
> and found a record full of blanks".  How would such a lookup ever fail?
> 
> --
> KenBrody at BestWeb dot net        spamtrap:

    Yes, I was having another senior "duh" moment.  It's become so automatic
over the past 30+ years to use the "-b" option and then do all the error
handling myself, after I pretend a lookup has succeeded, that, late in the
day, it didn't dawn on me to try the "-n" flag.

    By the way, I tested the "-n" flag this morning, and the processing
works without giving me an error. 

    As far as a "tip of the day", I copied this deletion routine from
another processing table written by somebody else that is dated 1986, and it
is working without errors with the "-b" option on the production server. I
believe it failed while I was testing it on the "test server" because I was
starting with a clean file on each run.  (no existing records in the
temporary file...)

    On the production server, there are always 10,000 pre-allocated blank
records.  At least that's the only thing I can think of that would cause the
"-b" to work for 30 years in a production environment, yet fail on my
smaller testing server...

Thanks,

Mike Schwartz       



More information about the Filepro-list mailing list