SELECT COUNT(*) into variable

[John Cosmas]

How do I run a SELECT COUNT(*) and put the results into a variable in code?

[Jack Jackson]

On Wed, 15 Jun 2005 12:53:33 -0500, "John Cosmas"

Post by John Cosmas
How do I run a SELECT COUNT(*) and put the results into a variable in code?

You can either use INTO ARRAY, or use the COUNT command instead of
SELECT.

Don't post into multiple newsgroups - almost everyone here reads them
all.

[newboy]

you can also use the _tally variable to get the records count after you use
the SELECT or other SQL statment.

Post by John Cosmas
How do I run a SELECT COUNT(*) and put the results into a variable in code?