Home » Developer & Programmer » Forms » How to populate specific data from database into list item?
icon14.gif  How to populate specific data from database into list item? [message #670471] Fri, 06 July 2018 07:37 Go to next message
rehmankhan
Messages: 22
Registered: July 2018
Junior Member
created ListItem1 with List Style (Poplist) for department no (10,20,30) and other ListItem2 with List Style (Tlist) for employees name. Record group for employees name

When i click on department no.10 then populate all employees name data into ListItem2. I want to populate data only employees names who falls under department no.10 or 20 or 30

CODE:

DECLARE

a VARCHAR2(100);
num NUMBER := 10;

BEGIN

a := populate_group ('R1');
populate_list ('LIST1','R1');

END;
"LIST1" for populate employees name data "R1" is a group record name
Re: How to populate specific data from database into list item? [message #670490 is a reply to message #670471] Mon, 09 July 2018 03:55 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you want to be able to perform queries in the block that holds the list items?
Because if do then due to various quirks of how forms uses list items you don't want to do this.
Forms restricts queries by the contents of list items. If the row contains a value for the list item that isn't in the lists current set of recognised values then it is silently ignored when you issue a query.

Dynamically populated list items in forms are deeply problematical for this reason. Use an LOV instead.
Previous Topic: How to use select_all option in list items?
Next Topic: Save image from Server to Client System
Goto Forum:
  


Current Time: Thu Mar 28 20:46:30 CDT 2024