| Search form Creating Locks [message #619839] |
Fri, 25 July 2014 08:29  |
jolly_makkar
Messages: 63
Registered: March 2008
|
Member |
|
|
Dear Friends
I created Search form for Customers
Search_Block(Non-Database block) contains search options
Customers block where result gets populated (Database Block -Master block)
Customer Detail Block(Database Block -Detail block)
When Users Search results ,the moment data gets populated in Master-Detail blocks.In Toad,it starts showing exclusive lock.
Other Transactions for users are hanging.
I traced Session ,it showed me statement . Quote:Select col1,col2 ......FOR UPDATE NOWAIT.
How can i avoid FOR UPDATE ? As i just want to retrieve data for selection ,without any update
For Searching i am using Quote:SET_BLOCK_PROPERTY('CUSTOMER_BLOCK',DEFAULT_WHERE,where condition)
Regards
Aman
|
|
|
|
| Re: Search form Creating Locks [message #619843 is a reply to message #619839] |
Fri, 25 July 2014 08:38  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
How does data get populated? By the default behavior forms action which is the query the block, or are you overriding the default behavior and using INSERT to populate your form?
|
|
|
|
| Re: Search form Creating Locks [message #619854 is a reply to message #619843] |
Fri, 25 July 2014 09:10 |
jolly_makkar
Messages: 63
Registered: March 2008
|
Member |
|
|
I am changing the CUSTOMER_BLOCK with DEFAULT_WHERE like one of the Search criteria
If :Search_Block.Name is NOT NULL THEN
Set_Block_Property(CUSTOMER_BLOCK,DEFAULT_WHERE ,--where clause string--)
Go_Block (CUSTOMER_BLOCK);
Execute_Query;
It populates the result but locks the Customer Table for other Users .
Then Execute_Query
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
