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