 Error : Using Combo Box . [message #213102] |
Tue, 09 January 2007 08:42  |
|
|
HI ALL,
i have a problem with dynamic combo .
| Quote: | i want to use comb-box instead of LOV.
|
for that i open my form 6i and
>conn scott/tiger.
>create datablock emp.
>change the properties-palette of dept no as 'LIST ITEM' and clear values from 'element in list 'property and set 'list style' property as combo.
then write the following codeon the "when-new-from-instance" of module.
DECLARE
R_ID RECORDGROUP;
STATUS NUMBER;
list_id item:=find_item('DEPTNO');
BEGIN
R_ID:=CREATE_GROUP_FROM_QUERY('RG_P','SELECT DNAME,DEPTNO FROM DEPT');
STATUS:=POPULATE_GROUP('RG_P');
POPULATE_LIST('DEPTNO',R_ID);
if id_null(R_ID) then
message(status) ;
else
message('list_id');
end if;
END;
but when i compile my form i got error >>
frm-32082 : invalid value fromgiven item type.
list deptno
item:deptno
block :emp
form :module1
frm-30085:unable toadjust form for output.
i have also try and change the 'data type' property of 'DEPTNO' from number to 'char' and set 'length' to 20 . but
at this time form execute successfulybut igot an other error >>
| Quote: | frm-41336 :populate_list:invalid column type for column 2.
|
can someone help me to solve my problem ?
regrads.
[Updated on: Tue, 09 January 2007 08:48] Report message to a moderator |
|
|
|
|
|
| Error : Using Combo Box . [message #413460 is a reply to message #213102] |
Wed, 15 July 2009 19:52  |
fcossio@gua.net
Messages: 1
Registered: July 2009
|
Junior Member |
|
|
Please, modify your query and convert the second column to character using the function To_Char. Example:
Select dname, To_Char(DeptNo) From Dept
It will work!!
Best regards
Fernando CossÃo
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
