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

Re: Sql Count

Jason:


Try this:


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


Hope that works.

Les


--- Jason Rupp <jrupp@TECHNEGLAS.COM> wrote:
> 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!!


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com