problem of populating record group [message #258315] |
Sat, 11 August 2007 00:23 |
fam_bila
Messages: 43 Registered: August 2007 Location: pakistan
|
Member |
|
|
helo,
i made a record group name as "RECORD_GROUP2"
on this i write code
select session_no
from sesion
then i made a canvas , on canvas i place a list item name as "list_id" and a button label as "id" now i want that when i click on button the data of record group populated on list item, for this i write code on button
BEGIN
Populate_List('list_id','RECORD_GROUP2');
END;
but on complation i got a error
FRM-30351: No list elements defined for list item.
List LIST_ID
and on runtime when click on button an error occour
invalid record group for list population
now please tell me what is the problem with this process.
thanx
|
|
|
|
|
|
|
Re: problem of populating record group [message #259600 is a reply to message #258508] |
Thu, 16 August 2007 01:46 |
fam_bila
Messages: 43 Registered: August 2007 Location: pakistan
|
Member |
|
|
as u say :
If you have defined the record_group in the Forms Builder and associated it with an LOV and associated that LOV with an item you don't need to do a manual 'populate_list'. It will be done by the Form at runtime. Remove the manual 'populate_list' and see what happens.
so:
i make a record_group and associate it with a LOV. but i don't know how to associate it with the list item.
plz tell me
waiting ur reply
thanx
|
|
|
Re: problem of populating record group [message #259623 is a reply to message #258315] |
Thu, 16 August 2007 02:31 |
sispk6
Messages: 164 Registered: November 2006 Location: pakistan
|
Senior Member |
|
|
1...dont enclose LIST_ID in quotes or use list_name
or
2... compare the data types for campatability
or
3 ... increase the length of field you want to populate
or
4 ... use id_null to verify whether list_id is found or not
regards
PEACE
|
|
|
|
|
Re: problem of populating record group [message #259638 is a reply to message #259632] |
Thu, 16 August 2007 02:48 |
musman
Messages: 147 Registered: July 2007 Location: Lahore
|
Senior Member |
|
|
declare
rg_name VARCHAR2(40) :='TYPEID';
rg_id RecordGroup;
gc_id GroupColumn;
errcode NUMBER;
begin
CLEAR_LIST('EMPLOYEE.TYPE_ID');
--CLEAR_LIST('groupname,itemname)this is what u have to write here
rg_id := Find_Group(rg_name);
IF Id_Null(rg_id) then
rg_id := Create_Group(rg_name);
gc_id := Add_Group_Column(rg_id,'DESCRIPTION',CHAR_COLUMN,60);
gc_id := Add_Group_Column(rg_id,'TYPE_ID',CHAR_COLUMN,3);
end if;
errcode := Populate_Group_With_Query(rg_id,'select description,type_id from emp_type');--write your query in it..
POPULATE_LIST('EMPLOYEE.TYPE_ID',RG_ID);
--groupname,itemname
end;
--------------------------------------
use this code in trigger when_new_form_instance
at form level
IS IT OK
[Updated on: Thu, 16 August 2007 02:55] Report message to a moderator
|
|
|
Re: problem of populating record group [message #259974 is a reply to message #259638] |
Fri, 17 August 2007 01:18 |
fam_bila
Messages: 43 Registered: August 2007 Location: pakistan
|
Member |
|
|
hi
we have tried almost every possible solution to solve our problem
but not succeded.
the way you told us also tried but we have an error as:
FRM-30351: No list elements defined for list item.
plese help us.
thanx
|
|
|
|
Re: problem of populating record group [message #260333 is a reply to message #258315] |
Sat, 18 August 2007 09:31 |
hemavb
Messages: 103 Registered: May 2007 Location: Dubai , UAE
|
Senior Member |
|
|
fam_bila,
In the list item at desgin time put a black line in the List elements. Element label as single space and element value as single space.
The eror that you are specifyin will go off.
When you are populating a list dynamically, the procedure will always overwrite/replace any details tthat you have defined at design time.
Regards-
Hemavb
|
|
|
|
|