Home » Developer & Programmer » Forms » create a module from a specific select statement
create a module from a specific select statement [message #635922] Mon, 13 April 2015 02:01 Go to next message
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
Re: create a module from a specific select statement [message #635927 is a reply to message #635922] Mon, 13 April 2015 03:24 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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.
Re: create a module from a specific select statement [message #664499 is a reply to message #635927] Thu, 20 July 2017 05:53 Go to previous message
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.
Previous Topic: Server and Stations Problem
Next Topic: Oracle Forms Newbie question :)
Goto Forum:
  


Current Time: Thu Jul 29 23:14:41 CDT 2021