Re: Sql Count

["Ross, Steven" <sross@KCM.ORG>]

Here's another way...

        begin-select
        Count(*)        &count
        from ps_job
        end-select

Using "begin-select" is the usual way to do a select in SQR.

HTH,

Steven Ross
Applications Developer/Analyst
sross@kcm.org
 



-----Original Message-----
From: Stephen Keen [mailto:stephen_keen@SQR-SERVICES.COM]
Sent: Saturday, January 05, 2002 12:23 PM
To: SQR-USERS@list.iex.net
Subject: 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!!