TClientDataSet Aggregate questions

Article View: borland.public.delphi.database

Article #174

Back to borland.public.delphi.database Previous Next

#174

From: dankell
Date: Fri, 01 Feb 2008 15:31

28 lines
2045 bytes

I am trying to work my way around nested TClientDatasets to see if
they do what I need them to.  I am building a small league application
as an example.

I currently have 2 TClientDataSets:

1) Matches, containing fields for:

   Date, Time, HomeRef, HomeName, HomeScore, AwayRef, AwayName,
AwayScore

2) Teams, containing:

   Ref, Name

Matches looks up its names from Teams and all is well.  What I am
having problems with is getting aggregate information for the tables.

I would like to find from the Matches table the count of all the
matches played per team, and the goals for / against for each team.

Am I right in thinking that these aggregate fields will need to be on
set on the Matches dataset?  And will I need interim fields to get to
where I want (e.g. GoalsForHome, GoalsForAway)?

Cheers

Dan

Technical Details

Message-ID: <8eb4cf8a-626e-4323-a4a0-1e7fcae79c39@e25g2000prg.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e25g2000prg.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,7efdf629c69950a9,start
X-Google-Attributes: gid115d96,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e25g2000prg.googlegroups.com!not-for-mail
From: dankell <deadlock@mac.com>
Newsgroups: borland.public.delphi.database
Subject: TClientDataSet Aggregate questions
Date: Fri, 1 Feb 2008 07:31:59 -0800 (PST)
Organization: http://groups.google.com
Lines: 29
Message-ID: <8eb4cf8a-626e-4323-a4a0-1e7fcae79c39@e25g2000prg.googlegroups.com>
NNTP-Posting-Host: 213.52.162.226
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1201879920 29131 127.0.0.1 (1 Feb 2008 15:32:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 1 Feb 2008 15:32:00 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e25g2000prg.googlegroups.com; posting-host=213.52.162.226; 
 posting-account=RXcosQoAAABptDT7l5szWFOM6RQ1uY7I
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 
 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR
 3.0.04506.648),gzip(gfe),gzip(gfe)