>I have a table where the key field is index a candidate index and field a want change is a regular index. I get the message
>
>Failed to update table, Unique index violation
>
>The error number is 1884. How do I change the second value, i,e, from a "B" to an"A"?
No, you want to update a field that is involved in Primary or Candidate index :-)
And that violates the rule.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
