Home » Developer & Programmer » Forms » need urgent replies (forms)
need urgent replies [message #305354] Mon, 10 March 2008 09:06 Go to next message
Messages: 8
Registered: March 2008
Junior Member
how to populate the items into a display item from a database during the run time.

with regards
Re: need urgent replies [message #305359 is a reply to message #305354] Mon, 10 March 2008 09:15 Go to previous messageGo to next message
Messages: 20
Registered: January 2006
Location: US
Junior Member

You can select the data from the DB into the item


The logic can be put in after the execute query is called or can be inserted into the
POST_QUERY trigger for a single record block. If the form does not let you populate
the values on a display item you can enable the item and disable it after the value is

Harsha Vakkalanka
Re: need urgent replies [message #305414 is a reply to message #305354] Mon, 10 March 2008 12:56 Go to previous message
Messages: 3
Registered: March 2008
Location: Kingdom Of Saudi Arabia
Junior Member
To Populate Items Into A Display Item From Database

Write Post Query Trigger On Block Label....


Suppose We Want To Display Dname In To Emp Table Then

Create A Display Item With Name Dname
And In Property Pallete Set Database Database Item=No

And Write Post Query Trigger On Emp(Block Label)

Select Dname Into :Dname From Dept Where Deptno=:Deptno;

All The Best....

Previous Topic: trigger for closing a form
Next Topic: export huge data to spreadsheet
Goto Forum:

Current Time: Mon Aug 21 09:04:58 CDT 2017

Total time taken to generate the page: 0.08627 seconds