Update Query fails due to Key Violations.
Posted on 2002-05-07
Im am trying to perform an update query on a table that contains 2 Primary Keys but when i try and call the query i get the following message:
Cant update all the records in the Update Query.
Tivoli Fixes didnt update 0 field(s) due to a type conversion failure, 20 record(s) due to key violations, 0 record(s) due to lock violations and 0 record(s) due to validation rule violations.
i looked in the help - and it suggests that within the code i can use the Primary Proerty and change the primary keys to non-primary while i perform the update query and then set them back. Please could you help me on how i would do this?