Q:
Duplicate record
When attempting to rewrite a record after moving/changing one of the components of the key, it hits a error - ie. duplicate key. But after investigation using sql, there is no such existing key value in the database. Why is this happening ?
ASKED:
May 9 2009 0:05 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
///////////////////////////////
Focus on the keyfields of the primary - use DSPFD to determine the keys
The value of the combined key fields must be unique.
Check for logical files - DSPDBR physical
if any of these are UNIQUE then their keys also cannot be duplicated.
Check your code - you maybe attempting to write the same record twice.
Phil
