Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RecCount() equivalent in SQL-Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
RecCount() equivalent in SQL-Server
Miscellaneous
Thread ID:
00181733
Message ID:
00181733
Views:
40
I am creating some cursors on a SQL-Server, so with the SQL Pass through, there is no record set returned to VFP.

At present, after creating the cursor, I issue a
select count(*) from table

which I do have the results returned to VFP to determine the number of records created. Is there some stored procedure that will just return this number from some system table??? It takes quite a while especially on tables of 500,000 or more records.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform