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

Re: Sql Count

This si a begin-select not begin-sql.  Begin-sql is only for dml.

-----Original Message-----
From: Jason Rupp [mailto:jrupp@TECHNEGLAS.COM]
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!!