Record Lock in Subfile
Hi all,
I am trying to find any keyword which is used to lock the record in Subfile. Please find the scenario:
Let assume two users are trying to read the same record on the subfile from different session. Now when the 2nd user was trying to read any record while 1st user is using same record from different session I want to moniter that error and show the error message to user as "This record was using by somebody else".
Please suggest me necessary solution.
Software/Hardware used:
I am trying to find any keyword which is used to lock the record in Subfile. Please find the scenario:
Let assume two users are trying to read the same record on the subfile from different session. Now when the 2nd user was trying to read any record while 1st user is using same record from different session I want to moniter that error and show the error message to user as "This record was using by somebody else".
Please suggest me necessary solution.
Software/Hardware used:
ASKED:
September 22, 2009 11:13 AM
UPDATED:
September 22, 2009 2:37 PM
Answer Wiki:
You cannot lock the subfile record unless you locked all the records in the subfile.
But, you when a user selects a record, you can lock the DB record that is associated with the record.
You would do this by doing a chain and having the file identified as an Update File.
This is not a good solution as the user could walk away fromn this task and hte record would stay locked.
Generally, you take care of this programmatically..
When you write the subfile record, include a hidden fields of the database record.
Then when someone tries to do an update, compare the database record with the values in the hidden fields. If they do not match, someone else updated the record. nad you can display a message.
To see all answers submitted to the Answer Wiki: View Answer History.
Go to:
http://www.think400.dk/downloads.htm
About a third of the way down the page you will find a program called “Show Record Lock”. You should be able to modify it to do what you want.