Im generating an application log when some field values are changed.
I'm locking the DB using BAL_DB_ENQUEUE when 1 user is performing updates.
When another user is trying to update the same records he is unable to do so till the lock is released.
The program waits for the lock to be released and does not proceed till the lock is released.
I want to display a message in the log saying "records locked" instead of waiting for the lock to be released . how do i do this?
Please help me.....
have you tried to work with lock objects (SE11) in your program ?? Create a lock object for you database and then, you can use the generated object in your program.
The first user that works with the table blocks it automatically. Any other user that tries to access the table will get a message from the system indicating that the table is blocked.