>How do I know how many records are in a Select cursor?
>
>If I do "Select * from Cities where city='HOUSTON" I get just a few records, but if I print Reccount() I get several hundred thousand (the entire database rcooord count).
The _TALLY will tell you how many records are in the result set. Add NOFILTER or READWRITE clause to the SELECT to preveny VFP from creating filtered cursor. After that _TALLY and RECCOUNT() will return the same count.
--sb--