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