OraFAQ Forum: Forms » How to populate specific data from database into list item?

Home » Developer & Programmer » Forms » How to populate specific data from database into list item?

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

How to populate specific data from database into list item? [message #670471]

Fri, 06 July 2018 07:37

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

Report message to a moderator

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

cookiemonster
Messages: 13966
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.

Report message to a moderator

Previous Topic:	How to use select_all option in list items?
Next Topic:	Save image from Server to Client System

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 10:22:48 CDT 2025