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
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108