Multiple lookups to the same file with different aliases?

Kenneth Brody kenbrody at bestweb.net
Fri Jun 15 05:54:12 PDT 2007


Quoting Mike Schwartz (Thu, 14 Jun 2007 20:25:15 -0500):

> >>    Multiple lookups to the same file with different aliases?
>
> >Of course you can do that.  That's one of the reasons for aliases.
>
> As a follow up to my own post, be SURE you "protect" your lookups if
> you are going to be writing to the records you have looked up.  This
> becomes especially important if you're doing multiple aliased lookups
> to the same file.

It's important regardless of how many aliases you have on the same file.
I'm not sure if it's "more important" if you have multiple aliases.

>      When I've been called in to debug filePro code after the original
> filePro programmers have thrown in the towel, the most common bug I
> find is that a programmer has not protected a lookup with the "P" flag.
> It's so common that the first thing I do to a processing table is to
> grep out all the lookups, and try to ascertain whether the lookup is
> probably being written to but the record is not protected.

Don't forget about PFCHECKLOCK=ON.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list