General information
Category:
Coding, syntax & commands
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only