>I have a Table with a key index field specified as 'Primary' type.
>I have 'SET DELETE ON'. When a record was deleted with
>the DELETE command, I wanted to append the same key
>into the Table, but it says "Uniqueness violated". Why is that so?
>Any advise please.....
Alvin
Delete does NOT remove the record from the table -- only PACK will do that. Just because you cannot see the record does not mean it still does not exist. You will either have to pack the table first or change the key value so it is unique.
HTH,
Tom