usage of TAggregateField

Article View: borland.public.cppbuilder.database.multi-tier

Article #92

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#92

From: Emmanuel
Date: Sun, 29 May 2005 00:03

30 lines
1640 bytes

Dear All,

I have some ClientDataSets

TClientDataSet*ClientDataSetA ;
TClientDataSet*ClientDataSetB ;

TDataSource *DataSourceA :

DataSourceA->DataSet =ClientDataSetA

ClientDataSetB->MasterSource=DataSourceA
ClientDataSetB->MasterField="FieldA"
ClientDataSetB->IndexFieldNames="FieldA;FieldB"

I want to calculate the sum of the current FieldC of ClientDataSetB under
the relationship of ClientDataSetA
but I found that the TAggregateField must be some every record igrone the
MasterSource information
How to I do it?

I cannot use the TDataSetField, because there are so many table relate to
ClientDataSetA;
but TDataSetField can only handle 1 master dataset and 1 detail dataset
without bug
please teach me if you know

thank you

Emmanuel

Technical Details

Message-ID: <42990615@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fcd2b,b881263a5100eda9,start
X-Google-Attributes: gidfcd2b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Emmanuel" <emmanuel@erphk.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: usage of TAggregateField
Date: Sun, 29 May 2005 08:03:38 +0800
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 221.127.230.83
Message-ID: <42990615@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1117324821 221.127.230.83 (28 May 2005 17:00:21 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail