>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.