| poplist [message #488856] |
Tue, 11 January 2011 12:53  |
 |
memua
Messages: 27
Registered: January 2011
Location: riyadh
|
Junior Member |
|
|
hi
i have a column in my datablock comming from another table i want to select all its values in that other table and put it in my poplist so that when the user is selecting it it stors in this table too
please help
hope you understood what i meant
|
|
|
|
|
|
| Re: poplist [message #488919 is a reply to message #488913] |
Wed, 12 January 2011 04:36  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
You'll probably want to use the populate_list and create_group_from_query builtins. Form builder help lists the syntax for both with examples.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: poplist [message #489455 is a reply to message #489447] |
Sun, 16 January 2011 14:23 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
It could be we're not answering you cause we haven't been on the internet all day. I've only just seen this, you need to learn some patience.
I told you to use populate_list, you haven't.
The when_list_changed doesn't make a lot of sense.
This:
if NVL(LENGTH( (:PAYMENTS.EMLPLOYEE_ID) ),0)<>0 then IF :PAYMENTS.EMLPLOYEE_ID IS NOT NULL
Populating and then immediately deleting a group is pointless. You have to assign it to the list item first - using populate_list.
Thisset_item_property('payments.emlployee_id', QUERY_DATA_SOURCE_NAME, v_query);
I also don't understand why you're using execute_query or raise form_trigger_failure in that trigger.
The when-new-form-instance looks ok at a glance except that the variable I should be a number not a varchar. I would have used populate_list rather than add_list_element. Does it do what you expect?
|
|
|
|
| Re: poplist [message #489548 is a reply to message #489455] |
Mon, 17 January 2011 08:17 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
cookiemonster wrote on Sun, 16 January 2011 15:23you need to learn some patience.
And manners.
If it's so important to you to get an answer right away, then pay a consultant or put in an SR with Oracle. We are not a paid service here. We are all volunteers.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
