>>>>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).
>>>
>>>
>>>Select *, COUNT(*) AS RcCount from Cities where city='HOUSTON INTO CURSOR cTest
>>>? RecCount("CTest")
>>>? CTest.RcCount
>>>
>>
>>Note that if you omit the NOFILTER clause, reccount() may return all records from the table, not just the selected records.
>
>I think, that when I put COUNT(*) in select VFP store the result in cursor not in filtered table?
Yes, you are right; I overlooked that part.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)