| Locking of rows from forms-6i [message #79245] |
Sat, 18 May 2002 01:20  |
Nirmal
Messages: 39
Registered: November 2000
|
Member |
|
|
How can I prevent users from updating a particular row and give him a proper error message when the same row is being updated by another user?
(I have done it by the use of LOCK_RECORD built-in. but it failed to provide proper error message to the users)
|
|
|
|
| Re: Locking of rows from forms-6i [message #79252 is a reply to message #79245] |
Mon, 20 May 2002 00:44  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
|
forms automatically takes care of the locking records, in most of the case you do not have to do anything. of two user try to update record at same time then d2k gives the error. only thing you have to do is catch the error in on-error trigger and provide proper error message.
|
|
|
|
| Re: Locking of rows from forms-6i [message #79819 is a reply to message #79245] |
Tue, 16 July 2002 19:25 |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
Hi,
I would like to know the procedure, suppose if a user is working on 50 records, that records should not be accessed by another user and if the user logs in first he should be alloted first 50 records and if the second user logs in then next 50 and so on.If the user is performing operation on those 50 records the records should not be assigned or operated by another user.
thanx
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
