| How to populate Combo Box -> Static Record Group? [message #227718] |
Thu, 29 March 2007 03:00  |
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 #227735 is a reply to message #227718] |
Thu, 29 March 2007 04:03  |
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!  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!!!!
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
