Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reccount() for a select
Message
From
18/10/2005 18:39:21
Mike Yearwood
Toronto, Ontario, Canada
 
 
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:
01060094
Views:
14
>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).

VFP cheats sometimes and just sets a filter on the table when you run a query. See the NOFILTER keyword in the SQL help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform