<div>
I am just curious what was wrong with <br />
COUNT FOR (Rerort_YR) = '*'<br />
<br />
because it is syntacticaly correct statement (only the field name is wrong) and the result is stored into _TALLY variable.<br />
<br />
COUNT and RECCOUNT() may differ if the table contains deleted records.
</div>


<div>
<div class="content wysiwyg-content">
I need to know haow many rows of data are in a table in a Foxpro 9 database table.<br />
<br />
I found this on the Microsoft site but it returns an error saying &quot;command contains unrecognized Phrase/Keyword&quot;.<br />
<br />
USE transaction_2012<br />
<br />
CLEAR<br />
COUNT FOR (Rerort_YR) = '*'<br />
<br />
Database name is test<br />
Table name is transaction_2012<br />
field name in table 2012 is Report_yr<br />
<br />
Thanks in advance for the help
</div>
</div>


I need to know haow many rows of data are in a table in a Foxpro 9 database table.

I found this on the Microsoft site but it returns an error saying "command contains unrecognized Phrase/Keyword".

USE transaction_2012

CLEAR
COUNT FOR (Rerort_YR) = '*'

Database name is test
Table name is transaction_2012
field name in table 2012 is Report_yr

Thanks in advance for the help

I am just curious what was wrong with 
COUNT FOR (Rerort_YR) = &#39;*&#39;

because it is syntacticaly correct statement (only the field name is wrong) and the result is stored into _TALLY variable.

COUNT and RECCOUNT() may differ if the table contains deleted records.

Count rows in Visual Fox Pro 9 table

I need to know haow many rows of data are in a table in a Foxpro 9 database table.

I found this on the Microsoft site but it returns an error saying &quot;command contains unrecognized Phrase/Keyword&quot;.

USE transaction_2012

CLEAR
COUNT FOR (Rerort_YR) = &#39;*&#39;

Database name is test
Table name is transaction_2012
field name in table 2012 is Report_yr

Thanks in advance for the help

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.