Deleted key not fournd

[Linda Gray]

Do you need a write after a delete?

-----Original Message-----
From: Jeff Harrison [mailto:jeffaharrison at yahoo.com] 
Sent: Wednesday, December 14, 2005 11:11 AM
To: Linda Gray
Cc: filepro-list at lists.celestial.com
Subject: Re: Deleted key not fournd


--- Kenneth Brody <kenbrody at bestweb.net> wrote:

> Quoting Linda Gray (Wed, 14 Dec 2005 10:29:19
> -0600):
> 
> > Hello,
> >
> > We are running web front ends for filepro
> processing/ databases.  In one
> > file that I deleted some of the records, I keep
> getting the 'Delete key
> > not found' and it locks up the web application and
> leaves the fp process
> > hung. We are using linux/unix and fp 5.0.
> 
> Which release of 5.0?
> 
> > I thought this problem was solved long ago but its
> happening again, at
> > least for me.  Is there anyway to turn it off? 
> The fp process is
> > executed from a cgi script so there is no one to
> hit the enter key, so
> > it hangs.
> 
> Try "PFBIXERRORS=OFF", or the more generic
> "PFMBTO=1".
> 
> --

This will stop the errors from hanging the process,
but it of course does not address the cause of the
errors.  You should make a note of the index(es) that
are giving you the deleted key not found message, and
then make sure that your application never writes or
deletes to that file from an unprotected lookup
statement.  That means that you should add the -p flag
to any lookup that will subsequently be used to modify
a record.  Also, make sure that you issue a write
after you are done with the modifications so that the
lock is released.

Once you are sure that the appropriate lookups are
protected, then you should rebuild all of the
associated indexes.

I believe that Ken once demonstrated that the Deleted
key not found message is appropriate in certain
circumstances where the programming allowed for
modification unprotected records.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com