Locked Record Issue

[Nancy Palmquist]

OK I figured a few things out.

First, you can not use LOCKED(file) eq "1" on an IF line, you have to 
only use Locked(file)

Second, you have to check for LOCKED before you check for NOT metro.

In my tests, if the record was locked then the logic on line 12 was true 
and it never got to the check for the LOCKED record.  I guess the -w on 
the lookup line will treat locked records like the lookup failed, 
instead of waiting for the lock to release. (Verified  by the docs.)

So check for LOCKED first then check for NOT.

You have to use the -w or the waiting happens at the LOOKUP and never 
continues to anything after that.

So that seems to be how you get it to work.

Sequence is:

lookup blah  -nx*pw*
if *Locked(lookup)*  then do whatever.
If *not lookup* then do whatever.

I know I am supposed to wait for responses but I get on a roll and since 
I got the flow worked out, I thought I would share to others.
Nancy



On 6/26/2014 2:05 PM, Nancy Palmquist wrote:
> Ken,
>
> I tried this abbreviated logic to see what was happening. I get a syntax
> error at LOCKED( on line 13
>
> If I put Locked(metro) eq "1" on an IF line I get the syntax error at EQ.
>
> 10 ------- - - - - - - - - - - - - - - - -
> @keyr ■ If: ■
> Then: ke(10,.0)="999" ■
> 11 ------- - - - - - - - - - - - - - - - -
> ■ If: ■
> Then: lookup metro=metrodb k=ke i=a -nxpw ■
> 12 ------- - - - - - - - - - - - - - - - -
> ■ If: not metro ■
> Then: end ■
> 13 ------- - - - - - - - - - - - - - - - -
> ■ If: ■
> Then: n(5,.0)=LOCKED(metro) ■
> 14 ------- - - - - - - - - - - - - - - - -
> ■ If: n eq "1" ■
> Then: msgbox "LOCKED RECORD" ■
> 15 ------- - - - - - - - - - - - - - - - -
> ■ If: ■
> Then: end
> On 6/26/2014 12:19 PM, Kenneth Brody wrote:
>> On 6/26/2014 12:11 PM, Nancy Palmquist wrote:
>>> Fellow filepro developers,
>>>
>>> I just wondered if anyone could save me some time testing out a possible
>>> solution to a problem.
>>>
>>> In a clerk session, (filepro 5.0 version) I have a lookup to a file like
>>> this:
>>>
>>> lookup file=myfile k=ke i=a -nxp
>>>
>>> Can I tell right at that point if the record is locked and move
>>> somewhere else in the programming?
>>>
>>> if Locked(file) eq "1" then "do something"
>> [...]
>>
>> You're already 99% of the way there...
>>
>> Add the 'W" flag to the lookup:
>>
>>      Then:  lookup file=myfile k=ke i=e -nxpw
>>
>> Then you can test with:
>>
>>        If:  locked(file)
>>      Then:  ... do something ...
>>

-- 
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140626/65042ada/attachment.html