User-Defined parameters in GROUP BY clause

[Sonica Vij <sonica@EXACTONE.COM>]

Hi,

I've been facing problems with a the attached program. Please let me know
why its not recognizing my GROUP BY clause.

Here is the error on running it the command-line options:
sqrw MQuery_Success.sqr sql/root/root -KEEP -S -rs -ZIV @jobs.input

**********************************************
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 8118 in cursor 2:
   [INTERSOLV][ODBC MS SQL Server 6 driver][Microsoft SQL Server]Column
'JobsSit
es.SiteName' is invalid in the select list because it is not contained in an
agg
regate function and there is no GROUP BY clause.
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 8118 in cursor 2:
   [INTERSOLV][ODBC MS SQL Server 6 driver][Microsoft SQL Server]Column
'Jobs.Co
brand' is invalid in the select list because it is not contained in an
aggregate
 function and there is no GROUP BY clause.

Error on line 72:
   (SQR 3716) Error in SQL statement.


Errors were found in the program file.

SQR: Program Aborting.

Cursor Status:

 Cursor #1:
   SQL = SELECT SiteName, Cobrand, (count( Furnituresites.Furniture_id )),
         (sum( Furnituresites.NumberOfItems ))  From  Furniture,
         FurnitureSites Where Furniture.Furniture_id =
         FurnitureSites.Furniture_id Group By SiteName, Cobrand Order By
         (sum( FurnitureSites.NumberOfItems ))
 Compiles = 1
 Executes = 0
 Rows     = 0

 Cursor #2:
   SQL = SELECT SiteName, Cobrand, (count( Jobssites.Jobs_id )), (sum(
         Jobssites.NumberOfItems ))  From  Jobs, JobsSites Where
         Jobs.Jobs_id = JobsSites.Jobs_id And Cobrand = ? Group By
         SiteName,Cobrand Order By (sum( JobsSites.NumberOfItems ))
 Compiles = 1
 Executes = 0
 Rows     = 0

Thanks!

-- Sonica


-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Stan Quick
Sent: Thursday, November 30, 2000 4:29 PM
To: SQR-USERS@list.iex.net
Subject: Re: CALL SYSTEM IEXPLORE.EXE


If you don't want to include the path in the command, you have 2 options
1) Copy IEXPLORE.EXE into a directory that is part of your path (not
recommended), or
2) Add the directory to your path (on my NT, it's in c:\Program
Files\Internet Explorer)

You then use
call system using 'iexplore' #stat nowait

Stan
-----Original Message-----
From: Mike Morgan [mailto:MMorgan@CHASEMELLON.COM]
Sent: Thursday, November 30, 2000 3:56 PM
To: SQR-USERS@list.iex.net
Subject: Re: CALL SYSTEM IEXPLORE.EXE


I hope somebody knows the answer..that would be so COOL!

> -----Original Message-----
> From: Emmanuel Perron [SMTP:emmanuel.perron@JONQ.CGI.CA]
> Sent: Thursday, November 30, 2000 3:16 PM
> To:   SQR-USERS@list.iex.net
> Subject:      CALL SYSTEM IEXPLORE.EXE
>
> Hi,
>
> What is the syntax for executing IEXPLORE.EXE from sqr?
**************************************************************
NOTICE: The information contained in this e-mail is confidential and may be
privileged or otherwise protected from disclosure.  This e-mail is intended
solely for the use of the named addressee.  Please be aware that any other
use, printing, copying, disclosure or dissemination may be subject to legal
restriction.  If you are not the intended recipient, please notify us
immediately by return e-mail to the sender.