Home » Developer & Programmer » Forms » form help
form help [message #226728] Mon, 26 March 2007 06:00 Go to next message
Messages: 47
Registered: March 2007
I have three block , A, B, C

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 #226736 is a reply to message #226728] Mon, 26 March 2007 06:31 Go to previous messageGo to next message
Messages: 67
Registered: July 2006
Location: Bangalore
Your requirement is not clear.
Attach your form then only figure out something.

Re: form help [message #226868 is a reply to message #226736] Mon, 26 March 2007 16:09 Go to previous message
Messages: 21146
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
which returns more than one value, or perhaps as a subquery like
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.
Previous Topic: calculated item problem
Next Topic: restrict mouse on queried records only
Goto Forum:

Current Time: Thu Aug 17 10:37:09 CDT 2017

Total time taken to generate the page: 0.08937 seconds