>>>>>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.
>//:^)
Why should I post original message? And BTW everything is still here, nothing was cut off.
Edward Pikman
Independent Consultant