Kbase P4401: Error 6146 occurs for UPDATE or DELETE operations
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/16/2006 |
|
Status: Verified
FACT(s) (Environment):
MS SQL DataServer
ODBC DataServer
SYMPTOM(s):
Error (6146) for UPDATE or DELETE operations
Table/View <table> does not have a unique key, cannot fetch a record by recid.(6146)
SELECT operations complete appropriately
CAUSE:
No unique key defined in the foreign data source table to support the RECID / ROWID function
FIX:
Create an unique index on the table then update the schema holder definitions. This unique index must comply with the unicity of the data stored in the table.