Hi Cristi,
When you have define LOV property for text item.
The TEXT item is LOV enabled , that is if you double click this text item. The match LOV popup for you.
Or another trick ways, you can create another BUTTON near this text item. And just give a when-button-pressed triggen with " show_lov('LOV_NAME') ; " .
That is another way to you.
Some other ways , you can write a trigger to insert LIST ITEM's list value.
But for ORACLE FORM DEVELOPER designed.
Using LOV the the best way then LIST,
Also , please open help on FORM DEVELOPER .
Search by "LOV"
It given a lots example or description.
Regards
Wilson
-----Original Message-----
From: cristi dirdala
[mailto:oracledba-ezmlmshield-x11655053.[Email address protected]
Sent: Thursday, June 28, 2007 8:50 PM
To: LazyDBA Discussion
Subject: oracle forms
hi, I would like to ask you for some help.
I need to create a form and for this reason I use Oracle Forms and Reports; I would like you tell me if you got knowledge of other product doing same thing.
I do have a problem because I want to crate a list - a combo box - or equivalent, that I would like to contain data from a table already built into tha database - so I need to put a result from a select statement (select distinct column_x from table_y) into the list, but I cannot resolve the problem this way. I noticed that using LOV-s (list of value), I can do some things, but using a text item, not a list item, and things are not all right because when I have to chose a value from the result of the select statement, I need to use the main menu to select - "show list".
I would like you tell me if you know a source of examples for the beginning steps in building oracle forms.
Thank you in advance for your effort.
--
English Version:
This message has been scanned for viruses and
dangerous content by OpenProtect, and is
believed to be clean.
Versiunea Romana:
Mesajul a fost scanat de OpenProtect si este
considerat a fi neinfectat.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page