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


Here is deptno field for which list need to populate

DECLARE 
  rg_name  VARCHAR2(40) := 'deptno'; 
  rg_id    RecordGroup; 
  errcode  NUMBER; 
BEGIN 
--	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 ); 
  end;
  • 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
djmartin
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'.

David
Previous Topic: select and deselect
Next Topic: QUERYING BLOB (IMAGES)
Goto Forum:
  


Current Time: Mon Aug 21 08:52:52 CDT 2017

Total time taken to generate the page: 0.04694 seconds