Thanks Jim. I actually (just) read the thread with the advice of Fred Taylor.

That would be a nice option. Especially the auto-recycling of records.

Anyways, take it easy and have a nice day,

Joe

>Joe,
>
>Walter wishes for a TABLE property that could be set at table design time or modified only with an exclusive USE of the table that wouuld:
>
>1) DEFAULT to exactly as things are today,
>
>2) Optionally, ALWAYS treat Deleted() records as NON-EXISTENT so that, as an example, "active" keys (Primary, Candidate, etc.) can be created even if the same key value already exists in a deleted record.
>
>3) Same as #2 but with the inherent functionality of RECYCLING deleted records (if any exist in fact) whenever an APPEND BLANK or INSERT (SQL) is run.
>
>I think that sums it up.
>
>You can probably get at the thread by going to Sunday last in calendar. Near the bottom is the thread and you should hopefully be able to MAP once in a thread message.
>
>Jim N
>
>>Hi.
>>
>>A dialog stating
>>"The autolink feature is only available to members of the Premier..."
>>popped-up. So, what you did worked, but not for me.
>>
>>Anyways, what was the wish (in as few words as possible)?.
>>
>>Joe
>>
>>>Hi Joe,
>>>
>>>See Thread #277228 and if this worked as I hope you should just be able to click on the highlighted number to see it.
>>>
>>>Cheers,
>>>
>>>Jim N
>>>
>>>>I am not familiar with the WISH...does he want to be able to set whether or not a record is actually purged when it is deleted?
>>>>
>>>>Joe
>>>>
>>>>>In addition, one could indicate support for Walter M's recent WISH for a TABLE "property" to indicate how DELETED() records are desired to be handled.
>>>>>
>>>>>Cheers,
>>>>>
>>>>>Jim N
>>>>>
>>>>>>Well, you can issue a PACK command.
>>>>>>
>>>>>>You need exclusive use of the table for this and you will purge all records marked for deletion.
>>>>>>
>>>>>>If this is not good, you can blank out the data before deleting the record (in case the issue is sensitivity of information).
>>>>>>
>>>>>>You can also blank records and re-use them if you would like...
>>>>>>
>>>>>>Depends on your situation...
>>>>>>
>>>>>>Joe
>>>>>>
>>>>>>
>>>>>>>hi,
>>>>>>>
>>>>>>>anybody can help me..
>>>>>>>
>>>>>>>I want to delete a record but i dont want to mark it as deleted i want to delete it permanetly...
>>>>>>>
>>>>>>>TIA