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
shahzaib_4vip@hotmail.com
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,
empno,
ename into
:Block1.deptno,
:Block1.empno,
: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

Regards

Shahzaib isamil

Re: Basic Select Statement [message #408438 is a reply to message #408436] Tue, 16 June 2009 04:15 Go to previous message
cookiemonster
Messages: 12422
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 change Radio Button Visual Attribute ?
Goto Forum:
  


Current Time: Sat Dec 10 04:55:23 CST 2016

Total time taken to generate the page: 0.04866 seconds