Home » Developer & Programmer » Forms » frm-41075 error deleting group (oracle forms 10g ,win xp pack 2)
frm-41075 error deleting group [message #574527] Fri, 11 January 2013 12:31 Go to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
Hi,
i used item list in my form ,i want to fill this item list ...but i encountered this error 'frm-41075 error deleting group' !!!
here is the code :

//when-new-form-instance

declare

errcode number;
group_id RecordGroup;
group_name varchar2(10) :='group_emp';

begin

group_id := find_group(group_name);
if not id_null(group_id) then
delete_group(group_id);
end if;

group_id := Create_Group_From_Query(group_name,'select TO_CHAR(id) from emp');

errcode := Populate_Group(group_id);
Populate_List('block.emp',group_id);

end ;


Re: frm-41075 error deleting group [message #574556 is a reply to message #574527] Sat, 12 January 2013 11:20 Go to previous messageGo to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
heeeeeeeeeeelp me!!!!
Re: frm-41075 error deleting group [message #574624 is a reply to message #574556] Mon, 14 January 2013 06:18 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
I doubt it's the delete_group that's causing the error.
To populate a list item from a query the query needs two columns - first is the value that's displayed on screen, second is the value that's stored in the DB when you change the list item.
Re: frm-41075 error deleting group [message #574634 is a reply to message #574624] Mon, 14 January 2013 07:47 Go to previous message
goldray
Messages: 104
Registered: December 2012
Senior Member
ou are right the problem is related to the query, it must contain two columns ..
Previous Topic: Connect to 2 databases
Next Topic: Web-Util Configuration on 11g Forms
Goto Forum:
  


Current Time: Thu Apr 17 20:56:29 CDT 2014

Total time taken to generate the page: 0.10552 seconds