| Retrive many rows into a data block?? [message #338890] |
Wed, 06 August 2008 03:36  |
rania$$
Messages: 11
Registered: July 2008
|
Junior Member |
|
|
Hi All,
I have a select statement which returns all the Childs of a specific project so the select statement will return many rows.
I want to add a data block in the forms to display these rows in the screen (I want this block in purpose of displaying the results only) from the select statement.
I tried to add a non data base data block and I put the select query in the main block as (post query) to retrieve the rows in the non data block items.
After I do query the non data block retrieve only one record and the form raise ORA-01403: exact fetch returns more than requested number of rows.
So how can I make the non data block multi record to display all the results from the select query??
|
|
|
|
| Re: Retrive many rows into a data block?? [message #338921 is a reply to message #338890] |
Wed, 06 August 2008 04:50  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Wouldn't you rather create a simple master-detail form? Doing so, you wouldn't have to base the detail block on SELECT statement.
If you, however, choose to continue the path you've described, then base this block's Query Data Source Type must be "FROM clause query" which would be written into the Query Data Source Name block's property. You'd also have to manually create all Query Data Source Columns, as well as ever item in the block. Quite a tedious, dull job.
If possible, I'd suggest you to use master-detail form created by Wizard.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
