| list item [message #322430] |
Fri, 23 May 2008 08:53  |
pune
Messages: 2
Registered: May 2008
Location: toronto
|
Junior Member |
|
|
I have created a list item spriden.spriden_id in oracle forms 10g and tried all the 3 list type combo, tlist, poplist. In when-list-changed trigger I typed the below code. At run time, I get the blank list. I created record group product_name in oracle form object navigator with the below qry,though I think that is not required. Please suggest.
DECLARE
group_id RecordGroup;
List_id Item := Find_Item('spriden.spriden_id');
status NUMBER;
BEGIN
/* ** Create a two column query record group called** product_name. */
group_id := Create_Group_From_Query('product_name','SELECT spriden1.spriden_id, spriden1.spriden_id FROM spriden1');
status := Populate_Group('product_name');
/* ** Populate the List item with the values from the ** product_name record group. */
Populate_List(List_id,group_id);
END;
|
|
|
|
|
|
| Re: list item [message #322865 is a reply to message #322672] |
Mon, 26 May 2008 08:34  |
pune
Messages: 2
Registered: May 2008
Location: toronto
|
Junior Member |
|
|
NO it does not give any error. It gives a blank list, though query returns data.
Puneet
|
|
|
|
| Re: list item [message #331562 is a reply to message #322865] |
Fri, 04 July 2008 00:38 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Have you solved your problem?
Create the list BEFORE going into the field. The 'when-list-changed' trigger tells you that the list has changed. Do not create the list in this trigger.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
