Home » Developer & Programmer » Forms » populating_group error???help??
populating_group error???help?? [message #132303] Thu, 11 August 2005 18:23 Go to next message
ramisy2k
Messages: 150
Registered: April 2005
Senior Member
Hi

I have a form in which there are two windows...
on window 2 I have tlist and when i move from window 1 to window 2 through clicking a button the tlist popoluates using the following query...


declare
my_rg_id RecordGroup;
v_error number;
begin
my_rg_id := create_group_from_query('my_rg', 'SELECT...');

v_error := populate_group(my_rg_id);
if v_error = 0 then
populate_list('tlist.name, my_rg_id);
END IF;
end;

the problem is that when I need to get back to window 1 from window 2.. I close the window 2 and come bact to window 1..now if i again press the button to move again to window 2 the form gives me errors like

FRM-41072: cannot create group my_rg
FRM-41076: Error populating group

i just click the 'ok' button of two error messages and then finally come to window 2 again..and tlist is also populated...succesfully

pls tell me how to remove this error..??
Re: populating_group error???help?? [message #132315 is a reply to message #132303] Thu, 11 August 2005 19:42 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Searching this forum for 'create_group_from_query' would give you http://www.orafaq.com/forum/m/128104/67467/?srch=create_group_from_query#msg_128104

Basically, you need to test to see if the group already exists and if it does delete it before creating it a second time.

David
Previous Topic: Drag.pll
Next Topic: Clear Blocks
Goto Forum:
  


Current Time: Fri Sep 20 04:29:01 CDT 2024