RETRIEVING MORE THAN ONE ROW IN FORM [message #573082] |
Thu, 20 December 2012 12:02 |
|
msat_param
Messages: 4 Registered: December 2012
|
Junior Member |
|
|
Hi,
i have created two data blocks
First data data block contains a list item and a text item based on the selection of the list item and the value in the text item i need to retrieve more than one row in another data block whose NUMBER OF RECORDS DISPLAYED property are set to 10.
I have a Button in the first data block. So in the WHEN BUTTON PRESSED trigger i wrote SELECT INTO clause which is raising "exact fetch returns more than requested number of rows".
Then i used a cursor in the WHEN-BUTTON-PRESSED trigger in the first block to fetch row by row and assign it to the items in second block.
But i am able to retrieve only one record in the second block.
Pls help me out.
|
|
|
|
|
|
|
Re: RETRIEVING MORE THAN ONE ROW IN FORM [message #573239 is a reply to message #573185] |
Mon, 24 December 2012 11:34 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
msat_param wrote on Mon, 24 December 2012 12:39yes i did but it has to retrieve conditionally nah?
any how am facing the same prob.
What does that mean?
msat_param wrote on Mon, 24 December 2012 12:39
Thank you for replying can u pls try it and check it out?
Why don't you post the code you wrote? It'd make it a lot easier for us to understand what you're trying to do and what the problem is.
|
|
|