False Assigning to lookup field without a lock error messages

Scott Walker scottw1 at alltel.net
Thu Apr 13 17:18:54 PDT 2006


-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at bestweb.net] 
Sent: Thursday, April 13, 2006 7:36 PM
To: Scott Walker
Subject: RE: False Assigning to lookup field without a lock error
messages

Quoting Scott Walker (Thu, 13 Apr 2006 19:06:41 -0400):
[...]
> 	The three lookups to otscust1 are listed below.  All are
> protected.
>
>
> 	lookup bill1 = otscust1 k=l i=c -npx
> 	lookup bill2 = otscust1 k=3 i=a -npx
> 	lookup bill2 = otscust1 k=m i=c -npx
>
> When I run the process, I get:
>
> 	"Assigning to lookup field without lock."
> 	"Mainfile=otscustcodechg, lookfile=otscust1, prc=chgbill,
> line=469"
>
> This would seem impossible given the above lookup statements which are
> the only ones in this prc table that do a lookup to otscust1 file.

Ken asked:


Have you released the lock via a WRITE, sometime between the lookup
and line 469?


Ken,

No, the only time I use "write" on this file is a couple of lines AFTER
line number 469.  

The only thing that perhaps is a clue on this false error message (that
I can think of):


	The actual lookup statement is done much earlier in the
processing table to see if the Customer Code exists.  Then much later in
processing, after many intervening lookups, in a totally different
subroutine, I assign some values to a couple of the fields in the
otscust1 file using:

	bill1(1)=3


Then I write & close:

	write bill1

	close bill1


(BTW...I know that's overkill but this code goes back to 1988.)

Of course, it's on the bill1(1)=3 line that I get what I feel is the
false error.

Ken, thanks for your help on this.  It's not causing me a problem so
please don't worry about it.  I'm just gonna put PFCHECKLOCKPOPUP=OFF on
the menu script for this program and let it go at that.


Regards,


Scott
 




More information about the Filepro-list mailing list