What database are you using Steve?
> ----- Original Message -----
> From: "Steve Galyer" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Wednesday, 25 July 2001 15:47
> Subject: [DUG]: SQL Update question
>
>
> I have a Client table and a Card table, each client can have any number of
> cards, what I am attempting to achieve is to update a field in the Client
> table called CardIssuedTotal with the count of the cards associated with
> that client.
>
> I am using the following SQL statements, however I am getting an error
> "Parameter CARD.CardNumber has no default value"
>
> UPDATE CLIENT
>
> SET CLIENT.CardIssuedTotal =
>
> (SELECT COUNT(CARD.CardNumber)
>
> FROM CARD
>
> GROUP BY CARD.ClientNumber)
>
> WHERE (CLIENT.ClientNumber = CARD.ClientNumber);
>
> Any assistance appreciated.
>
>
>
> 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/
