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

Re: Sql Count

Try the following

begin-select
count(*) &Count

    let #var = &count

FROM PS_JOB
end-select


Regards,
Ian Mills
Analyst Programmer
ORIX Australia Pty Ltd

>>> jrupp@TECHNEGLAS.COM 04/01/2002 10:38:48 am >>>
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!!