Hi Lappies
I have forwarded your issue to the rocket support forum …
Good day
On Universe version 11.2.3 and earlier we had the following logic and it was working 100%.
We used the following command to determine if a record is already locked by another user. Using STATUS() Command to return the Pid no of the user.
[cid:CEF4CCDB-76B0-4B51-8D5B-471EA671DAF5]
In the example below, I locked a record from another session. The command above returned the record was locked by Pid 3116.
From the LISTU command we can then determine the user “SUPPORT” is locking the record.
PS! Please note that the PID no in LISTU and the USERNO in LIST.READU is exactly the same. 3116
[cid:8EE0A9E9-BC93-40E5-A61E-542BB9AD41CD]
The problem we have now is that we have found this code does not to work the same on the UV releases after 11.2.3
I am testing this on UV 11.3.1
I locked a record , then ran my program (Image 1) and it returned PORT = 2.
From the LISTU below you can see there is no PID 2 , but when doing a LIST.READU there is a USERNO 2
Before the PID and USERNO were the same but they are different now.
[cid:FD8CA863-FF41-4178-A09F-F1064C116720]
Can you please provide a simple solution to this problem?
Is there another command to use instead of STATUS() to determine the PID no that is locking the record?
I know we can use LIST.READU to find the USERNO 2 and get from there the PID 3860 and then via LISTU find the user,
but we need a simple way to know who the user is (USERNAME) that is locking a record.
Any help will be appreciated.
[TecApps ES 4-07]
--
Jorge Catalino | Tecfinity Pty Ltd
Sent from my iPhone
www.tecfinity.co.za