>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
Chris McCandless
Red Sky Software