OraFAQ Forum: Forms » Database column in a non-database block

Home » Developer & Programmer » Forms » Database column in a non-database block

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

Database column in a non-database block [message #410808]

Tue, 30 June 2009 06:34

santosh_x20
Messages: 9
Registered: June 2009
Location: india

Junior Member

is it possible to read database column and display in non database block in oracle forms 10g Laughing

Report message to a moderator

Re: Database column in a non-database block [message #410817 is a reply to message #410808]

Tue, 30 June 2009 07:12

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sure; a simple

SELECT some_column
  INTO :block.item_name
  FROM your_table
  WHERE certain_condition

would do the job. Such a code can be part of numerous triggers (such as POST-QUERY, WHEN-VALIDATE-ITEM, etc.)

I understand that you are new on the OraFAQ Forum. Welcome!
Though, please, try to get familiar with certain rules that apply while staying here (i.e. read the OraFAQ Forum Guide). You have put this question into an ancient (dated in 2003!) topic which was not related to your problem in any way. In order to test your posting abilities, please, visit our Test forum (you'll find it at the bottom of the forum list).

Report message to a moderator

Previous Topic:	accomdating more than 70,000 rows in an excel
Next Topic:	Menu Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:39:14 CDT 2024