Multiple lookups to the same file with different aliases?

[Scott Walker]

Denis Malen said:

Can you clarify the use of the -P, protected lookup. Is the list saying
that 
if you want to write to a lookup file that you use the -P? I was under
the 
impression that you use the -P only if you were pulling information from
the 
lookup file.

Can someone clarify or did I misunderstand the post.



Scott says:

I think you have that 180 degrees backwards.  You would use the -p to
protect the looked up record if you are going to be changing the data in
the looked up record.  There's no reason to protect a record if you are
just pulling in the data from it.  

Regards,

Scott




Thanks!

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Mike Schwartz" <mschw at athenet.net>
Cc: "'filePro Mailing List'" <filepro-list at lists.celestial.com>
Sent: Friday, June 15, 2007 8:54 AM
Subject: RE: Multiple lookups to the same file with different aliases?


> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> 

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list