Home » Developer & Programmer » Forms » list item (oracle forms 10g)
list item [message #322430] Fri, 23 May 2008 08:53 Go to next message
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 #322672 is a reply to message #322430] Sun, 25 May 2008 21:51 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is it giving any error?
Try to put a to_char over spriden1.spriden_id in the select while creating the group.

By
Vamsi
Re: list item [message #322865 is a reply to message #322672] Mon, 26 May 2008 08:34 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Oracle Forms and Reports Server Configuration
Next Topic: Update View
Goto Forum:
  


Current Time: Fri Dec 09 01:48:53 CST 2016

Total time taken to generate the page: 0.11190 seconds