>>>>how is an efficient way to tell if a table has no active records.
>>>>
>>>>thanks, brenda
>>>
>>>SET DELETED ON
>>>COUNT TO nTotal
>>>IF nTotal=0
>>>...
>>You should have and index tag on DELETED(), example...
>>INDEX ON DELETED() TAG ISDELETED
>>Having this will greatly increase performance if you have SET DELETED ON in your app.
>>
>>Assuming you have done this, you could...
>>
>>found_deleted=SEEK(.T.,'yourtable','ISDELETED')
>>
>>or conversely...
>>found_active=SEEK(.F.,'yourtable','ISDELETED')
>>
>>//:^)
>
>Larry, do you really assume that I don't use/know about DELETED() tag?
I know that you would, but you didnt post the original message.
//:^)