OraFAQ Forum: Forms » how to manually lock/unlock record in forms 6i with where clause

Home » Developer & Programmer » Forms » how to manually lock/unlock record in forms 6i with where clause

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to manually lock/unlock record in forms 6i with where clause [message #629115]

Wed, 03 December 2014 08:20

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how to manually lock/unlock record in forms 6i with where clause

regards

Report message to a moderator

Re: how to manually lock/unlock record in forms 6i with where clause [message #629117 is a reply to message #629115]

Wed, 03 December 2014 08:27

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

That makes no sense to me. Please use more words and an example.

Report message to a moderator

Re: how to manually lock/unlock record in forms 6i with where clause [message #629118 is a reply to message #629117]

Wed, 03 December 2014 08:32

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Dear i have data in three tables like master table and detail table and one column of master table exist on 3rd table and reterive data from 3rd table to master and detail table but some time multiple users open same data from 3rd table i want when 3rd table column used by any user message will appear to new user that column being used by another user wait...

Report message to a moderator

Re: how to manually lock/unlock record in forms 6i with where clause [message #629139 is a reply to message #629118]

Wed, 03 December 2014 13:38

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

If you want to lock the record when the record is queried I recommend you use the EXECUTE_QUERY() built-in with the FOR_UPDATE parameter; eg: EXECUTE_QUERY(FOR_UPDATE). When another user attempts to query the same record they will receive an FRM-40501: Could not reserve record n retries.

You can also control when Forms locks the record when an update occurs using the Locking Mode Block property. This is actually the preferred method. Take a look at the Locking Mode block property help topic for more information.

Craig...

Report message to a moderator

Previous Topic:	IMPORTING BULK DATA
Next Topic:	Not able to download Excel data from Oracle 10G with Window Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:18:35 CDT 2024