OraFAQ Forum: Forms » Populate List Item

Home » Developer & Programmer » Forms » Populate List Item (Oracle Dev Suite 10g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Populate List Item [message #302768]

Wed, 27 February 2008 00:02

mail2cmin
Messages: 3
Registered: January 2007

Junior Member

Hi

I have coded the following at form level trigger to populate list item using record groups.But I am unable to succeed.

Pls go through the code and help me.

-----------------------------------------------------------------
/*
** Built-in: CREATE_GROUP_FROM_QUERY
**Example: Create a record group from a query, and populate it.
*/
DECLARE
list_id ITEM;
list_name VARCHAR2(40) := 'ENAME';
rg_name VARCHAR2(40) := 'Employee_Names';
rg_id RecordGroup;
errcode NUMBER;
outcome NUMBER;
BEGIN
/*
** Make sure group doesn't already exist
*/
list_id :=Find_Item(list_name);
rg_id := Find_Group( rg_name );
/*
** If it does not exist, create it and add the two
** necessary columns to it.
*/
IF Id_Null(rg_id) THEN
rg_id := Create_Group_From_Query( rg_name,'SELECT ENAME FROM EMP');
END IF;
IF Not Id_Null(rg_id) THEN
Message('Record Group Created');
END IF;
/*
** Populate the record group
*/
errcode := Populate_Group( rg_id );
IF errcode = 0 THEN
outcome := GET_GROUP_ROW_COUNT(rg_id);
Message(outcome);

END IF;

Retrieve_List(list_id, rg_id);
Clear_List(list_id);
Populate_List(list_id, rg_id);

END;
-----------------------------------------------------------------

Report message to a moderator

Re: Populate List Item [message #302790 is a reply to message #302768]

Wed, 27 February 2008 00:45

dillango
Messages: 145
Registered: January 2008

Senior Member

Did you get any error message?

have you tried using this code?

populate_list('list_item','Recordgroup');

Where list_item is the item you created in the form and
the recordgroup will be associated with the list item.

Ilango

Report message to a moderator

Re: Populate List Item [message #302800 is a reply to message #302790]

Wed, 27 February 2008 01:09

dillango
Messages: 145
Registered: January 2008

Senior Member

Are you getting an error FRM-41334 (invalid record group)?
As such the code is correct. Can you try to create in predefined record group (through object navigator) instead of this?

I tried several attempt but I could not succeed. I started using LOV.

Please let me know if you successfuly populate it in list item.

I think the experts Mr.David and Mr.Littlefoot have not gone through this.

Ilango

Report message to a moderator

Re: Populate List Item [message #302806 is a reply to message #302800]

Wed, 27 February 2008 01:16

mail2cmin
Messages: 3
Registered: January 2007

Junior Member

Yes I have successfully done with the solution given by Vamsi Kasina.

It is a small change in the SELECT query.

Here it is......

-----------------------------------------------------------------

PROCEDURE Pop_List IS

/*
** Built-in: CREATE_GROUP_FROM_QUERY
**Example: Create a record group from a query, and populate it.
*/

list_id ITEM;
list_name VARCHAR2(40) := 'BLOCK3.item';
rg_name VARCHAR2(40) := 'Employee_Names';
rg_id RecordGroup;
errcode NUMBER;
outcome NUMBER;
BEGIN
/*
** Make sure group doesn't already exist
*/
list_id :=Find_Item(list_name);
rg_id := Find_Group( rg_name );
/*
** If it does not exist, create it and add the two
** necessary columns to it.
*/
IF Id_Null(rg_id) THEN
rg_id := Create_Group_From_Query( rg_name,'SELECT ENAME,ENAME FROM EMP',FORM_SCOPE,200);
END IF;
IF Not Id_Null(rg_id) THEN
delete_group(rg_id);
rg_id := Create_Group_From_Query( rg_name,'SELECT ENAME,ENAME FROM EMP',FORM_SCOPE,200);

END IF;
/*
** Populate the record group
*/
errcode := Populate_Group_with_query( rg_id,'SELECT ENAME,ENAME FROM EMP' );
IF errcode = 0 THEN
outcome := GET_GROUP_ROW_COUNT(rg_id);
Message(outcome);
END IF;

Clear_List(list_id);
Populate_List(list_id,rg_id);

END;
-----------------------------------------------------------------

Report message to a moderator

Re: Populate List Item [message #302811 is a reply to message #302806]

Wed, 27 February 2008 01:27

dillango
Messages: 145
Registered: January 2008

Senior Member

Yes,

It is working fine. HOwever, my doubt is
why it is not working when we give populate_list('list_item','record group').

I have created the record group having selecting same column two times.

Ilango

Report message to a moderator

Re: Populate List Item [message #330162 is a reply to message #302768]

Fri, 27 June 2008 14:30

speeler
Messages: 3
Registered: June 2008
Location: USA

Junior Member

I have used the pop_list procedure and it works great, but now the activity_date will not automatically populate and F10 will not save the data to the table.

Thank you for any help.

Steve

Report message to a moderator

Re: Populate List Item [message #337155 is a reply to message #330162]

Wed, 30 July 2008 01:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	Calling webutil functions from a library
Next Topic:	query data s into the jobs list

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 29 07:23:36 CDT 2025