Hi everyone,
Can someone please advise me as to what is happing with this SQL Select
statement I am trying to use
SQLCommand = vbNullString
SQLCommand = SQLCommand & "SELECT "
SQLCommand = SQLCommand & "PRODUCTCODE,"
SQLCommand = SQLCommand & "PRODUCTDESCRIPTION,"
SQ
, 2013 7:54 PM
Subject: [firebird-support] Help on this SQL statment
Hi everyone,
Can someone please advise me as to what is happing with this SQL Select
statement I am trying to use
SQLCommand = vbNullString
SQLCommand = SQLCommand & "SELECT "
SQLCommand = SQLCommand
, 2013 7:54 PM
Subject: [firebird-support] Help on this SQL statment
Hi everyone,
Can someone please advise me as to what is happing with this SQL Select
statement I am trying to use
SQLCommand = vbNullString
SQLCommand = SQLCommand & "SELECT "
SQLCommand = SQLCommand
zter
> Sent: 15 June 2013 5:57 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Help on this SQL statment
>
> GROUP BY PRODUCTDESCRIPTION there is PRODUCTCODE missing here
>
> if you use aggregate functions u have to add all fields to GROUP BY that
>
ust appear in the GROUP BY clause (so the server will know
> what value to return).
>
> On Sat, Jun 15, 2013 at 3:03 PM, Andrew gable >wrote:
>
>
> > I am sorry I Really do not understand :(
> >
> > -Original Message-
> > From: firebird-support@y
o the server will
> know
> > what value to return).
> >
> > On Sat, Jun 15, 2013 at 3:03 PM, Andrew gable > >wrote:
> >
> >
> > > I am sorry I Really do not understand :(
> > >
> > > -
Em 15/6/2013 16:54, Iwan Cahyadi Sugeng escreveu:
> Change it into this syntax:
>
> SQLCommand = vbNullString
>
> SQLCommand = SQLCommand & "SELECT "
>
> SQLCommand = SQLCommand & "PRODUCTCODE,"
>
> SQLCommand = SQLCommand & "PRODUCTDESCRIPTION,"
>
> SQLCommand = SQLCommand & "SUM(PRODUCTQTY),"
>
>