>>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.
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)