Re: Sql Count

[the dragon <ceprn@HOTMAIL.COM>]

begin and end select, not sql

clark 'the dragon' willis
dragon enterprises, sonsulting
Doing it right the first time, for less.

PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul.  Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you
have, and only you can determine how it will be spent.
Be careful lest you let other people spend it for you."

Carl Sandburg
(1878 - 1967)



----Original Message Follows----

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!!






_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com