>What is the quickest way to get a record count of a table which excludes the deleted records? Is there some function or something which does this quickly, other than set deleted on and copy to, or running through each record and doing a count on ones which are not deleted?
Also, if you add and index on DELETED() in your table, i guess the count will be faster ( not tested, sorry )
Jaime
Why do programs stop working correctly as soon as you leave the Fox?