>From the Access help:
This error occurs when the current query's Update To row includes a field
from either a crosstab query or select query in which an aggregate (total)
was calculated for the field (using either the Totals row or a domain
function in the Field row). To update a field using the aggregate of another
field, calculate the aggregate in the update query itself, not a different
query.
Looks like you have to change the code to something like:
UPDATE CLIENT SET CardIssuedTotal = DSUM("COUNT(*)","CARD",
"[ClientNumber]="&ClientNumber))
Yuk. (I'd still seriously question the need to denormalise though.)
Paul Ritchie
Radio Computing Services.
> -----Original Message-----
> From: Steve Galyer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 9:30 AM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: SQL Update question
>
>
> Thanks for the ideas BUT
>
> TADOCommand has the same problem
>
> Have tried the same query in Access in it also has the same
> problem - so the
> problem is with the Jet Engine - any experts on this out there.
>
> Steve Galyer
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
