Steve
You probably have RequestLive and are Opening the query where
you should be using ExecSQL, What connection method are
you using? Also you should paramerise ClientNumber as you
are updating the whole database (triggers would be easier)
HTH
Neven
----- Original Message -----
From: "Steve Galyer" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Wednesday, 25 July 2001 16:30
Subject: Re: [DUG]: SQL Update question
> This comes back with an error "Operation must use an updateable query"
>
>
> ----- Original Message -----
> From: "Neven MacEwan" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Wednesday, 25 July 2001 16:34
> Subject: Re: [DUG]: SQL Update question
>
>
> > Steve - 3 things
> >
> > 1/ count(*) is prob safer
> > 2/ brackets in the wrong place
> > 3/ Semicolon?
> >
> > Try
> >
> > UPDATE CLIENT
> > SET CLIENT.CardIssuedTotal =
> > (SELECT COUNT(*)
> > FROM CARD
> > WHERE CLIENT.ClientNumber = CARD.ClientNumber)
> >
> > Have you considered doing it in a trigger on CARD?
> >
> > HTH
> >
> > Neven
> >
> >
> >
> > ----- 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/
> >
>
> --------------------------------------------------------------------------
-
> 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/
>
---------------------------------------------------------------------------
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/
