| master detail block problem [message #602543] |
Thu, 05 December 2013 08:49  |
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  |
 |
Littlefoot
Messages: 21809
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
