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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic: maximising forms 10g
Next Topic: character to mouse conversion
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 21:44:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.