Home » Developer & Programmer » Forms » need urgent replies (forms)
need urgent replies [message #305354] Mon, 10 March 2008 09:06 Go to next message
vinaya.v
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
divya
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
vakkalan
Messages: 20
Registered: January 2006
Location: US
Junior Member

You can select the data from the DB into the item

SELECT 'DISPLAY'
INTO :ITEM
FROM TABLE_NAME

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
populated.

Harsha Vakkalanka
Re: need urgent replies [message #305414 is a reply to message #305354] Mon, 10 March 2008 12:56 Go to previous message
aliarshad77
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....

Example:-

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: maximising forms 10g
Next Topic: character to mouse conversion
Goto Forum:
  


Current Time: Thu Dec 08 14:11:11 CST 2016

Total time taken to generate the page: 0.06782 seconds