Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reccount() for a select
Message
From
19/10/2005 08:35:37
 
 
To
18/10/2005 18:39:21
Mike Yearwood
Toronto, Ontario, Canada
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:
01060203
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).
>
>VFP cheats sometimes and just sets a filter on the table when you run a query. See the NOFILTER keyword in the SQL help.

Yes, and any program that does something 'sometimes' - on its own whim - ought to have that "feature" removed!
Previous
Reply
Map
View

Click here to load this message in the networking platform