I've been putting off using databases with primary or candidate indexes and feel it's time to try them out.

How do you get around the Uniqueness is Violated error? Is there anything more savvy than populating the unique code field with something like '####' and going out and looking for a duplicate? Seems to me there should be something better than allowing it to come up with the error for you, and I'm sure that many of you have figured something out!

Thanx,
JR