Home » Developer & Programmer » Forms » list item
list item [message #236809] Fri, 11 May 2007 01:22 Go to next message
Messages: 47
Registered: March 2007
Can you one help , as Not able to populate the Deptno in List item.

Here is deptno field for which list need to populate

  rg_name  VARCHAR2(40) := 'deptno'; 
  rg_id    RecordGroup; 
  errcode  NUMBER; 
--	execute_query;
  rg_id := Find_Group( rg_name ); 
  IF Id_Null(rg_id) THEN 
    rg_id := Create_Group_From_Query( rg_name, 
                'SELECT deptno' 
               ||'FROM scott.dept ' 
  END IF; 
  errcode := Populate_Group( rg_id ); 
  • Attachment: dept.fmb
    (Size: 48.00KB, Downloaded 128 times)
Re: list item [message #236827 is a reply to message #236809] Fri, 11 May 2007 01:49 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I suggest using a Record_Group and LOV in the Forms Builder, then associate the LOV with your item.

If you MUST do it this way, search this forum or the reference manual for 'Create_Group_From_Query' or 'Populate_Group'.

Previous Topic: Problem with ..... " Run Form " button
Next Topic: deploying icons
Goto Forum:

Current Time: Thu Jun 29 09:28:48 CDT 2017

Total time taken to generate the page: 0.16406 seconds