>>Hello,
>>
>>I'm using a grid with table buffering (either optimistic or pessimistic). When I change the primary key of one record or delete one record (my primary has filter to exclude deleted records) and then want to add a new record with the old key the system prompts "uniqueness of index violated" immediately when changing the row. The system seems to ignore the previous change in the buffer.
>>
>>Any suggestions?
>>
>>It works fine with record buffering.
>>
>>Thanks in advance.
>>
>>Andreas Stolz
>
>Issue a TABLEUPDATE(.f.) after changing the key and before moving the pointer, this will update the buffer and the index and allow you to use the old key on a new record.
>
>HTH
Thanks. That's what I want to avoid, because with this solution I can't use tablerevert for this change.

Andreas Stolz