Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting Records
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00465935
Message ID:
00465960
Views:
10
Good idea. Thanks

>>I have a large table that I need to count the number of records on a regular basis. I was using - Count to nRecords - but it got to be too slow. So I created an index on Deleted() and am now using the following code. It is now instant.
>>
>>Does anyone see a problem with this? TIA
>>
>>Set Deleted Off
>>Select TableName
>>Count To nDel For Deleted()
>>Goto Bottom
>>nCnt=RecNo()-nDel
>>Set Deleted On
>
>There will be an incorrect nCnt if there is an ORDER set on the table (GOTO BOTTOM may not put you on the last RECNO()). You can replace the
>
>GOTO BOTTOM
>nCnt = RECNO() - nDel
>
>with
>
>nCnt = RECCOUNT() - nDel
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108
Previous
Reply
Map
View

Click here to load this message in the networking platform