| form help [message #226728] |
Mon, 26 March 2007 06:00  |
u263066
Messages: 47
Registered: March 2007
|
Member |
|
|
I have three block , A, B, C
A IS MASTER, AND B IS DETAILS OF A
B is master and c is details of B
The main query is based out of block A,
and when doing query, it is ending up with ereror more than one record fetch
2 relation has been made one with A AND B OTHER WITH B AND C
Can anyone help which block the query should be fired or should i need to write any pre-qury on block B
1. On query on Block A, only display last record of details table
2.cann't able to query on block B, what is best way to do so
|
|
|
|
|
|
| Re: form help [message #226868 is a reply to message #226736] |
Mon, 26 March 2007 16:09  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
TOO-MANY-ROWS error is a result of one of your SELECT statements. Check triggers/procedures/etc. you have written. You'll detect it as SELECT something INTO a_variable
FROM some_table
... SELECT something INTO a_variable
FROM some_table
WHERE some_column = (SELECT another_column FROM ...)
You'll have to fix it, one way or another (by further restricting fetched data set, using one of the aggregate functions (MAX, MIN, ...), or writing an exception handler section).
How to query block B? As block A is a top level block, you'll have to empty it, position to the B block and execute query on it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
