master detail block problem [message #602543] |
Thu, 05 December 2013 08:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
irfankundi786@yahoo.com
Messages: 269 Registered: February 2009 Location: pakistan
|
Senior Member |
|
|
i have one master block and it detail block---consolidate_code is in both block which make realtionship
in detail block i have pl_code,qty,amnt,rate
the qty and amnt should be sum and group by rate,pl_code now i place group by in where in detail block like this
group by rate,pl_code and consolidat_code=1
this should be like this
where consolidat_code=1 group by rate,pl_code
the master block code is placed after group by which genereat error...
|
|
|
Re: master detail block problem [message #602550 is a reply to message #602543] |
Thu, 05 December 2013 10:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I don't think that you can do it that way. It is "WHERE" data block property, not "WHERE AND GROUP BY". It helps you filter data retrieved in this block - pure WHERE clause, nothing special.
If you want such a fancy stuff, consider creating detail block on a view (instead of a table), as you can use
select ...
from detail_table
where ...
group by ...
In order to be able to enter values into the detail block, you'd use INSTEAD OF trigger.
|
|
|