<div dir="ltr"><div>Okay - after some more digging.....if I pull a record up directly in the filePro file itself and am in update mode...and then try to pull the account up in the processing that does all the lookups and protected lookups, I get 'Wating for 'mainfile' record xxxxxx to be unlocked'</div>
<div>But, if I pull up the record in the processing that does all the lookups and what the employees use to access the main file, it lets me pull it up with no problem?</div><div> </div></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Wed, Apr 16, 2014 at 1:33 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 4/16/2014 12:23 PM, Howard wrote:<br>
> What I mean is if you then make an assignment to that record it will not<br>
> re-lock it.<br>
> Yes if you re-lookup the record with a lock I think it will work but:<br>
> out(14)="Y"<br>
> write out<br>
> out(20)="1234"<br>
><br>
> Will leave the record from the lookup "out" unlocked and someone can go<br>
> into clerk and update it too.<br>
</div>[...]<br>
<br>
I'll have to see what happens here with that, as the second assignment<br>
should have filePro re-lock the record.<br>
<br>
Note, however, that even with filePro re-locking the record, the above<br>
construct is a "bad idea", as the record is unlocked between the WRITE and<br>
the next assignment to that lookup, and nothing stops another process from<br>
grabbing and updating the record in the time. It's the equivalent to<br>
executing an unprotected lookup and then assigning to it.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Kenneth Brody<br>
</font></span><div class="HOEnZb"><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>