Home » Developer & Programmer » Forms » LOV is displaying multiple times
LOV is displaying multiple times [message #261338] Wed, 22 August 2007 06:10 Go to next message
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 #261863 is a reply to message #261338] Thu, 23 August 2007 20:01 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In which triggers do you have the code 'show_lov'?

David
Re: LOV is displaying multiple times [message #261877 is a reply to message #261863] Thu, 23 August 2007 22:48 Go to previous messageGo to next message
krishna_jvs
Messages: 9
Registered: August 2007
Location: hyderabd
Junior Member
in when-button-pressed trigger i wrote that code
Re: LOV is displaying multiple times [message #261895 is a reply to message #261877] Fri, 24 August 2007 00:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
And to what did you attach this 'when-button-pressed' trigger?

David
Re: LOV is displaying multiple times [message #262028 is a reply to message #261895] Fri, 24 August 2007 06:35 Go to previous messageGo to next message
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 #262048 is a reply to message #262028] Fri, 24 August 2007 06:59 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, you have created a WHEN-BUTTON-PRESSED trigger which shows a list of values.

Every time you click on that button, list of values appears.

Is that your current situation?

What would you like to do? To click on the button only once and never again? If so, hide/disable it after the first click! However, how would you change item's value if there's no List of Values there any more? Confuse the user so that he'd have to use <Ctrl + L>?
Re: LOV is displaying multiple times [message #262332 is a reply to message #261338] Sun, 26 August 2007 03:56 Go to previous messageGo to next message
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 #262417 is a reply to message #262332] Mon, 27 August 2007 00:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
At which level do you have the 'pre-text-item' trigger?

David
Re: LOV is displaying multiple times [message #262419 is a reply to message #262332] Mon, 27 August 2007 00:20 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re:LOV is displaying multiple times [message #262459 is a reply to message #262422] Mon, 27 August 2007 02:04 Go to previous messageGo to next message
krishna_jvs
Messages: 9
Registered: August 2007
Location: hyderabd
Junior Member
thanks a lot hemavb
it's working with second one.
Re:LOV is displaying multiple times [message #262484 is a reply to message #262459] Mon, 27 August 2007 03:31 Go to previous message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
you are welcome.
Previous Topic: Not able to run the forms
Next Topic: Working with Text Attributes
Goto Forum:
  


Current Time: Thu Dec 08 22:20:45 CST 2016

Total time taken to generate the page: 0.11785 seconds