Home » Developer & Programmer » Forms » Values of a combobox from a select (Oracle FORMS 6)
Values of a combobox from a select [message #330013] Fri, 27 June 2008 05:52 Go to next message
averno9
Messages: 30
Registered: June 2008
Location: Spain
Member
Hi all.

I want to put a combobox that is filled with the contents of a query. For example, i have 2 tables, PERSON and CITY. They are like this:

PERSON
------
ID_PERSON NUMBER(3)
NAME VARCHAR2(20)
SURNAME VARCHAR2(20)
ID_CITY NUMBER(2)

CITY
----
ID_CITY NUMBER(2)
NAME VARCHAR2(25)

I want to show in each row of PERSON, instead of the city code, the name of the city, and when i push the combobox all cities that i have are shown. Whenever i try to commit, it will save in the DB the code, of course.

I tried several things. First of all i tried to create a form, an assisted block of person, another of city, and then create a relation between them. But it won't work, of course, i just tried the easiest thing i thought.

Searching for 'combobox' in this forum, it gave me an idea. Using a LOV. I would put the LOV in my combobox, with the id and the name of the city, and try it.

But i'm not really sure of what i have to do... ASP.NET has spoilt me too much i think, i would do this with 3 or 4 clicks, he he!

I tried to google this question, and i found everyone knows how to do this except me, so they don't explain how to do it. I searched on the help, and i didn't find anything useful.

Could you give me some guidance? I don't want that you do it for me, i'm learning and i want to suffer doing this, but could you tell me an url of a white paper, a class name, property or something?

Thanks a lot for reading, and sorry for my english.

[Updated on: Fri, 27 June 2008 05:55]

Report message to a moderator

Re: Values of a combobox from a select [message #337148 is a reply to message #330013] Wed, 30 July 2008 01:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Values of a combobox from a select [message #337162 is a reply to message #330013] Wed, 30 July 2008 01:29 Go to previous messageGo to next message
averno9
Messages: 30
Registered: June 2008
Location: Spain
Member
No, i haven´t. I tried to do it for a week, but i had a lot of job then, and i had to leave it.

I was just curious to know how to do it, but it wasn't something very important for my work.

Thanks a lot for asking.
Re: Values of a combobox from a select [message #339560 is a reply to message #337162] Thu, 07 August 2008 18:32 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
My suggestion is to create an LOV based on a record_group which has the entries in which you are interested, associate the LOV with an item so that when the 'show LOV' button is pressed the LOV appears, then as part of the LOV defined the name of the item into which the data is to be returned. Remember, you can return more than one component of the selected entry.

David
Previous Topic: Item Validation
Next Topic: running a form created in 6i in 10g(9.0.4) & Opening a Form created in 6i in 10g (merged)
Goto Forum:
  


Current Time: Mon Dec 05 21:19:43 CST 2016

Total time taken to generate the page: 0.05056 seconds