Re: Can some please help me with a duplicate key error

[mike browne]

Rick,

Thanks for replying to my problem.

> Was the INSERT part of a transaction? If so, what other statements were in the transaction?

I do perform a lookup before the insert to make sure that the booking code is not already on table, and if it is not then I do the insert.


> > Duplicate entry ''
> That is puzzling because it implies that the empty string is the offending value.

> Do you have an index called `key2` on some other table?

No I do not have any other index in the database called key2.

I am very perplexed as to what is causing this error.

Thanks

Mike