| How to retriev multiple records! [message #86521] |
Thu, 07 October 2004 19:26 |
pams
Messages: 4
Registered: October 2004
|
Junior Member |
|
|
Hi all!
I have two different blocks. Block1 has a text item 'Deptno' and a button 'View'. The other block(Block2) has several items in a tabular format like Deptno,Empno,Ename,Sal,etc and also a scroll bar. When I key in a Deptno(say 10) in block1 and press View button in block1 , it has to show all the details(deptno,empno,sal,etc) in that deptno(10) in the block2 items. I wrote a select with into statement for view button in the block1.It is working fine and also showing the particular deptno details in the block2. My problem is it is working fine for the deptno which has only one empno. If any deptno has many empnos, my query is not working and is giving the error(Exact fetch returns morethan one row). So anybody can help me!!!!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
