If I attempt to insert a record that has a duplicate key on a unique index, I get an error message of the form:
ERROR 1062: Duplicate entry '1' for key 2 I'd like to get a little more information so as to provide the user with a meaningful message. Specifically: what index is "Key 2"? Is there a way to retrieve this information without hard coding IXxxx is key 1, IXyyy is key2, etc. It seems that modifications to the table could break all the error messages if I hard code this. tia ---Michael
pgpQYXGkkWdcn.pgp
Description: PGP signature
