Haargggggggggggggg!

[couse1]

Hi,

I created a list item (list4), And i added the followed code :

DECLARE
group_id RecordGroup;
list_id Item := Find_Item('LIST4');
status NUMBER;

BEGIN
group_id := Find_Group('product_names');

IF NOT ID_NULL(group_id) THEN
DELETE_GROUP(group_id);
END IF;

group_id := Create_Group_From_Query('product_names','SELECT vil_nom,to_char(vil_id) vil_id FROM o2.o2_ville where vil_codepostal like "021%"');

DELETE_GROUP_ROW(group_id, ALL_ROWS);
status := Populate_Group(group_id);

Clear_list (list_id);
Populate_List(list_id,group_id);
END;

When I run my form it give me this error:
FRM-41072 Cannot create group product_name
???
could someone please help me out!

Thank you
Regard

Couse1

[stecal]

Are you looking for product_name or product_names?

[couse1]

I'm looking for product_names
I checked the code, it's not the problem.

regard
couse1

[stecal]

When I run my form it give me this error:
FRM-41072 Cannot create group product_name
???

You typed product_name in the forum post, but the actual output from Oracle was product_names?

[shibha]

(Edited to say never mind, I see your question is answered somewhere else)

'SELECT vil_nom,to_char(vil_id) vil_id FROM o2.o2_ville where vil_codepostal like "021%"'

I think your query could be wrong. I don't think you can use " (double quote) in it. Just try running your query from SQL or some other tool first.