>>>>>>>>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.
>>
>>I meant to say that I was responding to Brenda's message.
>
>You know, I understood this, so if you reply to particular person why not to do it right, i.e. really reply to particular person?
OKAY! OKAY! UNCLE! UNCLE! I got your point two messages ago!
//:^)