Advantage Error Guide
Problem: The key value produced from this record was not unique, and the index for the current table has the UNIQUE property.
Solution: Replace the key value field(s) with a unique value(s). If this is not possible, cancel the operation. When using the Advantage Client Engine API directly, call AdsCancelUpdate. When using the Advantage TDataSet Descendant, use the TTable.Cancel method.