Home » Developer & Programmer » Forms » Basic Select Statement (10g developer 6I window xp)
Basic Select Statement [message #408436] Tue, 16 June 2009 04:01 Go to next message
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Hellow all

I have 2 Block one contain 10 Record and second Contain 1 record

1st Block have 3 Column Deptno,Empno,Ename and Second Block only have Deptno

now i need when i enter Deptno of 2nd block and press ok button then select all Deptno,Empno,Ename in first block

I write this Query

Select Deptno,
ename into
:Block1.ename from emp where Deptno=:block2.deptno 

Its working but its show me only those record which deptno exist only 1 record

What can i do


Shahzaib isamil

Re: Basic Select Statement [message #408438 is a reply to message #408436] Tue, 16 June 2009 04:15 Go to previous message
Messages: 12820
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you want a query to populate multiple records you're going to need a loop.
But for this I would just create a relationship between the blocks and let forms default processing take care of it.
Previous Topic: Export Data in CSV format of particular Date
Next Topic: How to deploy forms 6i
Goto Forum:

Current Time: Sat Aug 19 08:17:33 CDT 2017

Total time taken to generate the page: 0.06588 seconds