Home » Developer & Programmer » Forms » populating list items
populating list items [message #459672] Mon, 07 June 2010 21:50 Go to next message
joannecylau
Messages: 3
Registered: June 2010
Junior Member
there are 3 radio buttons and 1 list item
i want different options to appear in the list item when choosing different radio buttons.
i've tried to compile the codes and there are no errors.
I dunno what went wrong. Could someone pls kindly help?

B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME

the following is my code:
DECLARE

it_id1 item;

V_SEVEN_ELEVEN RECORDGROUP:=NULL;

V_SEVEN_ELEVEN_STATUS NUMBER;

BEGIN
it_id1 := find_item('B_DEV.LIST_ITEM');
V_SEVEN_ELEVEN :=FIND_GROUP ('V_SEVEN_ELEVEN');
IF (:B_DEV.FOR_BANNERS = 'SEVEN_ELEVEN') THEN
SET_ITEM_PROPERTY ('B_DEV.SEVEN_ELEVEN', ENABLED, PROPERTY_TRUE);
SET_ITEM_PROPERTY ('B_DEV.MANNINGS', ENABLED, PROPERTY_FALSE);
SET_ITEM_PROPERTY ('B_DEV.GNC', ENABLED, PROPERTY_FALSE);

V_SEVEN_ELEVEN :=CREATE_GROUP_FROM_QUERY('V_SEVEN_ELEVEN',
'select env_name from env_mapping where instance_name = ''7-Eleven''');

IF NOT ID_NULL(V_SEVEN_ELEVEN) THEN
message('Testing');
message('Testing');
V_SEVEN_ELEVEN_STATUS := POPULATE_GROUP(V_SEVEN_ELEVEN);
message('Testing 1');
message('Testing 1');
POPULATE_LIST('B_DEV.LIST_ITEM',V_SEVEN_ELEVEN);
message('Testing 2');
message('Testing 2');
END IF;

end if;

END;
Re: populating list items [message #459685 is a reply to message #459672] Tue, 08 June 2010 00:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
'select env_name from env_mapping where instance_name = ''7-Eleven''');
Record Group should have two values, that too character datatype, if you want to attach that to LOV.
Use
'select env_name,env_name from env_mapping where instance_name = ''7-Eleven''');
By
Vamsi
Re: populating list items [message #459900 is a reply to message #459685] Tue, 08 June 2010 21:48 Go to previous message
joannecylau
Messages: 3
Registered: June 2010
Junior Member
ya it works now thanks a lot
Previous Topic: ORACLE 9I FORMS AND REPORTS
Next Topic: Webutil EXCEL download CLIENT_OLE2 stops when create obj
Goto Forum:
  


Current Time: Fri Sep 20 08:34:30 CDT 2024