Transactions with Database unique fields errors

Thanks for your reply.

yes that was a typo, the code provided was just a simple representation of the process the code goes through.

Funnily though i came into work today, and everything worked fine.

I can only assume there was some form of transaction error in which the database itself was unable to end a transaction?
Funny things computers :/