Home » Developer & Programmer » Forms » list of values (oracle forms10g,windows xp)
list of values [message #464490] Thu, 08 July 2010 03:33 Go to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
I have developed one sample form using oracle Internet developerSuite 10g.It has two fields.

1.allemployees(I set as combobox)

2.members (i set as text box)

In runtime allemployees column has all the employeename displayed .
If i select the employeename one by one it added into the members textbox.
How to solve that issue? kindly send the solution . I am new in oracle forms

thanks and regards

hanu

Report message to a moderator

Re: list of values [message #464632 is a reply to message #464490] Thu, 08 July 2010 09:56 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member
I think your question is not clear. What do you want to achieve?

Report message to a moderator

Re: list of values [message #464729 is a reply to message #464632] Fri, 09 July 2010 01:36 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
for example allemployees field has followingdata(set as combobox)

xxx
yyy
zzz
aaa

if i click tha allemployees coloumn it shows above values.i have an another field named as members(textbox).
I select xxx it stores into members field.again i select yyy that was also stores same members feld.



thanks and regards

hanu

Report message to a moderator

Re: list of values [message #464739 is a reply to message #464729] Fri, 09 July 2010 02:34 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Such as "members field = members field || employees"? (Concatenation operator)

Report message to a moderator

Re: list of values [message #464757 is a reply to message #464739] Fri, 09 July 2010 04:06 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
Sorry sir u dont understand my question.I have an field named as employeename(set as combobox).
From that field i retrieve all the employeename from my master table.around 500 employeenames are there.

i have an another field named as teammembers(set as textbox).

Suppose the project leader login the application ,he choose the members for the above field(employeename).
he choose five members one by one out of 500 employees,that five members stored one by one in teammembers textfield.




thanks and regards

hanu

Report message to a moderator

Re: list of values [message #465415 is a reply to message #464757] Wed, 14 July 2010 02:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David

Report message to a moderator

Re: list of values [message #465494 is a reply to message #465415] Wed, 14 July 2010 06:30 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
No.

Any body knows kindly send the solution.

thanks and regards

hanumanth

Report message to a moderator

Re: list of values [message #465545 is a reply to message #465494] Wed, 14 July 2010 11:51 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member
Your question is still not clear. Do you want to save the names into database or just want to display in the form.?If your requirement is just to display the names which you are selecting, then you can code in when-list-changed trigger of your list item 'employeename'
eg: 
:<block name>.teammembers := :<block_name>.teammembers ||' , ' || :<block name>.employeename;


If this it is not satisfying with your requirement, please attach the fmb or a screen shot of your form.

Report message to a moderator

Re: list of values [message #466301 is a reply to message #465545] Sun, 18 July 2010 23:29 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
i run the picklist.fmb form.I downloaded the form from demos.it shows following errror.


The select statement used for the built-in
Populate_Picklist_With_Query in the When-New-Form-Instance
trigger is invalid


Thanks and regards

hanu

[Updated on: Sun, 18 July 2010 23:37]

Report message to a moderator

Re: list of values [message #466308 is a reply to message #466301] Mon, 19 July 2010 01:02 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Fix it so that it becomes valid.
Do you really expect us to search for that form on the Internet, download it and search for the error? You must be kidding!

Please, provide some more information (if you expect any kind of help. If not, leave it as is).

Report message to a moderator

Re: list of values [message #466620 is a reply to message #466308] Tue, 20 July 2010 06:43 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
how to edit list item and enter a new item in runtime?

thanks and regards

hanu

Report message to a moderator

Re: list of values [message #466639 is a reply to message #466620] Tue, 20 July 2010 07:19 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is the list item static or based on a record group?

David

Report message to a moderator

Insert multiple items from listbox to database [message #466770 is a reply to message #466639] Wed, 21 July 2010 00:59 Go to previous messageGo to next message
vbhanumanth
Messages: 21
Registered: July 2010
Location: chennai
Junior Member
based on record group.I have an another issue.

I have a listbox where the style is tlist, now i want to save the items show in the listbox to my database through oracle forms.kindly sendly the solution.


thanks and regards

hanu

[Updated on: Wed, 21 July 2010 02:26]

Report message to a moderator

Re: Insert multiple items from listbox to database [message #466803 is a reply to message #466770] Wed, 21 July 2010 04:30 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If you want another item in the 'record_group' then add the item to the table on which the RG is based.

I suggest saving the items to the database and then use a 'record_group' to populate the list.

David

Report message to a moderator

Previous Topic: How to change the name in Run Time
Next Topic: utl packages
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 22:02:45 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.