| How to retriev multiple records! [message #86520] |
Thu, 07 October 2004 19:17  |
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!!!!!!
|
|
|
|
| Re: How to retriev multiple records! [message #86524 is a reply to message #86520] |
Thu, 07 October 2004 22:31  |
Biljana
Messages: 8
Registered: October 2004
|
Junior Member |
|
|
Select into is supposed to return one row. If it returnes more than one row, it failures.
You can do the query using command EXECUTE_QUERY (first do GO_BLOCK('Block2') command) instead of SELECT INTO...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
