| LOV is displaying multiple times [message #261338] |
Wed, 22 August 2007 06:10  |
krishna_jvs
Messages: 9
Registered: August 2007
Location: hyderabd
|
Junior Member |
|
|
i have created one lov. By pressing one button lov should display.
selected from the lov ,that lov is disabled till that functioning is perfect, after all the process where ever i am clicking the mouse on form it's enabling the same lov, even when i press exit button also it's coming.
|
|
|
|
|
|
|
|
|
|
| Re: LOV is displaying multiple times [message #262028 is a reply to message #261895] |
Fri, 24 August 2007 06:35  |
krishna_jvs
Messages: 9
Registered: August 2007
Location: hyderabd
|
Junior Member |
|
|
when focus goes to the textitem
in pre text item i made visible one button
once he press that button that lov will display
after selecting the value form the lov look up will return to that text item.
thats working well and good
problem i am facing after seleting that wherever on the form if i do mouse click first it is displaying that lov
|
|
|
|
|
|
| Re: LOV is displaying multiple times [message #262332 is a reply to message #261338] |
Sun, 26 August 2007 03:56 |
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
|
Senior Member |
|
|
check if you have placed a SHOW_LOV at the Block or Form level triggers.
One more thing might be... you must have set the item to validate from the LOV. In this case, if the value selected from te LOV is modified (and the modified value does not appear in the column of the LOV from which u are returning value to the form field) or no value is selected at all, the LOV will keep popping up. check it.
|
|
|
|
|
|
| Re: LOV is displaying multiple times [message #262419 is a reply to message #262332] |
Mon, 27 August 2007 00:20 |
krishna_jvs
Messages: 9
Registered: August 2007
Location: hyderabd
|
Junior Member |
|
|
to @hemavb
i have paced that trigger in block level
i have set that property validate-from-lov as enabled.
modified column values are displaying in respective text item.
and when i press save button it's storing in back-end with updated details
even when i press the save button also it's displaying that lov after selecting some value from that lov
it's getting saved into the database.
|
|
|
|
| Re: LOV is displaying multiple times [message #262422 is a reply to message #261338] |
Mon, 27 August 2007 00:31 |
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
|
Senior Member |
|
|
if it is a PRE-TEXT-ITEM trigger that you have placed at the BLOCK-level, it will be called EVERY TIME the cursor touches an item, which is EVERY time you enter in the form....
Do either one of the two...
*) Put the trigger in the ITEM level
OR
*) Put a condition in the existing trigger before calling the LOV... which wil check which is the item being called.
Some thing like..
IF :SYSTEM.CURSOR_ITEM = 'YOURBLOCK.YOURITEM' THEN
IF SHOW_LOV('YOURLOV') THEN
-- cODE
-- cODE
END IF;
END IF;
See if this works.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
