Subject Re: [ib-support] Master/Detail - Interbase
Author Dimitar Selensky
Thanks for the suggestion. I looked at and have carefully read the article
you gave me.

Using the built in aggregated fields is fine, but in the example at

only one summary field is displayed at a time: for example the total amount
by "Ship Via", so I get something like this:

DHL $10101.00

but in the current detail there is more than one group, so what I want is
something like that:

DHL $10101.00
UPS $40404.40

The question is: can the aggregate fields in tClientDataSet be connected for
example to a GRID which will display all the groups? it doesn't do much good
to see only one total at a time :(.

Best regards,
Dimitar Selensky

----- Original Message -----
From: "Sindu" <sindu@...>
To: <>
Sent: Wednesday, March 07, 2001 11:11 AM
Subject: Re: [ib-support] Master/Detail - Interbase

> Hi Dimitar,
> If you want a sum grouped by currency for the local data, actually
> TClientDataSet can do that automatically too. You just need to index the
> local data by currency, and then create an aggregate field with grouping
> level 1. To see more detail, check out the sample demo at
> {DELPHI}\Demos\Midas\Aggregate
> If it's more complex than that, I guess you'll have to do it manually.
> Hope this helps,
> Regards,
> Sindu
> On Wed, 7 Mar 2001, Dimitar Selensky wrote:
> > Cached updates, tClientDataSets - that's OK, thank you for the
> > and the nice URL.
> >
> > BUT, still, that doesn't solve one problem: if I have a local copy of
> > data I'm editing, I can not run a query against it. What am I going to
> > about that?! If there are just simple sums, it's OK, but mine usually
> > grouped by currency and the sum is multi line. It works very well with a
> > query, but I'll have to write it manually I guess.
> >
> > Any solutions? It sounds funny that one can not have a summarizing query
> > whenever there's a master/detail table involved. At least not before the
> > final POST, which doesn't do much good.
> >
> > Thank you,
> > Best regards,
> > Dimitar Selensky
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to