Record lock issue when performing lookup within current file

Josh Reader josh.reader at mercuryelectronics.com
Fri Jun 17 08:35:59 PDT 2016


It is v5.8 on CentOS 7.  I just made a few adjustments to the code (removed
the close commands and added a write command after updating the record in
the lookup) and activated the line syncing again.  I had the 3 buyers here
today go back to the main menu and in again.  If I have the issue still I'll
find out what record # it says is waiting to be unlocked.  I believe it was
a new record that someone was entering in a new PO on but I'll verify.

Thanks,
Josh

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net]
Sent: Friday, June 17, 2016 11:23 AM
To: Josh Reader; filePro Mail Group
Subject: Re: Record lock issue when performing lookup within current file

On 6/15/2016 3:26 PM, Josh Reader via Filepro-list wrote:
> Hi All,
>
> I am trying to program a feature for our purchasing dept and running
> into some lock issues.  Currently when our buyers have a PO line with
> multiple
[...]

What version of filePro is this?  I seem to recall an issue with a protected
lookup to the current file and a getnext loop could leave records locked,
but that was fixed quite some time ago.

Also, do you know what record is giving the "waiting for record to be
unlocked" message on the other workstations?

--
Kenneth Brody


More information about the Filepro-list mailing list