[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Sql Count

place the 'SELECT' after Begin-sql and before the Count


-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Jason Rupp
Sent: Thursday, January 03, 2002 6:39 PM
To: SQR-USERS@list.iex.net
Subject: Sql Count


Hello All:

I am trying to do a count - Select count(*) - in sqr and move the value
to a variable to be used later.  This is how I did it:

Begin-sql
count(*) &Count
FROM PS_JOB
End-Sql

What am I doing wrong?

Thanks for the help!!