OraFAQ Forum: Forms » create a module from a specific select statement

Home » Developer & Programmer » Forms » create a module from a specific select statement

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

create a module from a specific select statement [message #635922]

Mon, 13 April 2015 02:01

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hello guys,
I have two tables

A and B.
The Query is
__________________________________________________________

select A.e_no, A.e_name, A.d_no, A.e_amount, B.D_date
from A,B
where A.d_no = B.d_no
and e_no = :My_item

___________________________________________________
This Query always retrieve multiple records. I want the return values to be in an item for example ITEM60.
As well, My_item is an item in my block. As well, the query is executed inside a button.
This block should not modify any data from my database. I am using Oracle Developer 6i
plz, help

Report message to a moderator

Re: create a module from a specific select statement [message #635927 is a reply to message #635922]

Mon, 13 April 2015 03:24

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

Create a view. Base a block on the view. Set its update and insert allowed properties to No.

Report message to a moderator

Re: create a module from a specific select statement [message #664499 is a reply to message #635927]

Thu, 20 July 2017 05:53

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Thank You cookiemonster. Yes, It worked by creating a View of the data I wanted to show.

Report message to a moderator

Previous Topic:	Server and Stations Problem
Next Topic:	Oracle Forms Newbie question :)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 05:56:13 CST 2025