record locked (topics merged) [message #678571] |
Mon, 16 December 2019 07:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/dd7dfae0b2dae95edebd2238eadcebb6?s=64&d=mm&r=g) |
Boumati
Messages: 21 Registered: November 2019
|
Junior Member |
|
|
Hi,
Please, is there someone who can help me know if a record is locked in oracle/forms 6i.
I used the lock_record instruction and I want to know on the other hand how to know if the record is locked .
like this exemple :
if "record" is locked then ......
thank you a lot.
|
|
|
|
Re: record locked [message #678598 is a reply to message #678571] |
Wed, 18 December 2019 05:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I would think that if you try to lock it, you will get an appropriate message back if it is locked already.
|
|
|
|
|
|
|
|
Re: record locked [message #678604 is a reply to message #678603] |
Wed, 18 December 2019 08:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
That means it's locked.
That's how forms tells you it's locked.
Why do you want different behaviour?
And what exact behaviour do you want?
|
|
|
|
Re: record locked [message #678614 is a reply to message #678612] |
Thu, 19 December 2019 05:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
OK, so you now know that a row is already locked by another session. You need to define the "do something for competitive users". What do you want to do next?
|
|
|
Re: record locked [message #678621 is a reply to message #678612] |
Fri, 20 December 2019 15:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Boumati wrote on Thu, 19 December 2019 02:46
Hi,
I want to capture the error code and do something for competitive users
to make the program more adapted (ergonomic) under multi-users conditions.
It is NOT an error, it is just locked. Same thing as "Could not reserve record (#). Keep trying?" It is NOT an error.
I have no idea what the terms competitive and ergonomic mean in this context. They sound funny to me.
[Updated on: Fri, 20 December 2019 15:11] Report message to a moderator
|
|
|