Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reccount() for a select
Message
 
 
To
18/10/2005 18:14:14
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060078
Message ID:
01060087
Views:
12
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform