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 suggestion
> and the nice URL.
>
> BUT, still, that doesn't solve one problem: if I have a local copy of the
> data I'm editing, I can not run a query against it. What am I going to do
> about that?! If there are just simple sums, it's OK, but mine usually are
> 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