Home » Developer & Programmer » Forms » How to populate Combo Box -> Static Record Group?
How to populate Combo Box -> Static Record Group? [message #227718] Thu, 29 March 2007 03:00 Go to next message
HelpMePls
Messages: 2
Registered: March 2007
Location: Russia/Moscow
Junior Member
I am getting following error message while try to populate Combo Box, Oracle Form 6.0.8.11.3 (Oracle 8.0.5) which generates:

FRM-41076

SET_UP_LIST('my combo box','my record group');

Q: How to populate ComboBox? Static Record Group.

A static record group is not associated with a query; instead, you define its structure and row values at design time, and they remain fixed at runtime.static record groups can be created and modified only at design time.

q: so how to define its structure? and ComboBox Elements structure?


[Updated on: Thu, 29 March 2007 03:09]

Report message to a moderator

Re: How to populate Combo Box -> Static Record Group? [message #227729 is a reply to message #227718] Thu, 29 March 2007 03:38 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
At design time, you can fill the "elements in list" property. Or you can make a static record group (I believe it is a wizard that allows you to define fixed values). Or you can play around with the ADD_LIST_ELEMENT built-in.

MHE
Re: How to populate Combo Box -> Static Record Group? [message #227735 is a reply to message #227718] Thu, 29 March 2007 04:03 Go to previous message
HelpMePls
Messages: 2
Registered: March 2007
Location: Russia/Moscow
Junior Member
oh sry!

SET_UP_LIST is not built-in Forms! its procedure in module! Smile lol

PROCEDURE set_up_list(plist in VARCHAR2,pGroup in VARCHAR2) IS
vErrFlag number :=0;
eListPopulationProblem exception;
BEGIN
vErrFlag := Populate_group(pGroup);
if vErrFlag =0 Then
Clear_list(pList);
Populate_list(plist,pGroup);
elsif vErrFlag= 1403 Then
null;
else
null;
raise eListPopulationProblem;
end if;
exception
when others then
message('err...');

END; -- ONLY FOR QUERY RECORD GROUP!!!! Smile



PopulateList('my Block.my ComboBox','my RecordGroup');

The record group must have the following two column (VARCHAR2) structure:

Column 1: Column 2:
the list label the list value

thx all!

[Updated on: Thu, 29 March 2007 04:05]

Report message to a moderator

Previous Topic: Global Path
Next Topic: can't find menu for a called form
Goto Forum:
  


Current Time: Thu Dec 08 08:33:40 CST 2016

Total time taken to generate the page: 0.11161 seconds