FoxPro database connector - SELECT COUNT(*) into variable

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SELECT COUNT(*) into variable

John Cosmas

2005-06-15, 1:25 pm

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

Jack Jackson

2005-06-15, 1:25 pm

On Wed, 15 Jun 2005 12:53:33 -0500, "John Cosmas"
<johncosmas@charter.net> wrote:

>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

2005-08-11, 8:25 pm

you can also use the _tally variable to get the records count after you use
the SELECT or other SQL statment.
"John Cosmas" <johncosmas@charter.net> Ð´ÈëÏûÏ¢ÐÂÎÅ
:yWZre.7203$Ub4.6977@fe06.lga...
> How do I run a SELECT COUNT(*) and put the results into a variable in
code?
>
>

Sponsored Links