<p>Hello.. </p> <p>I have a form which when submittied, SQL creates a SHA1 hash of the information entered and checks it against existing entries in the database. If an entry already exists, the end-user is notified of such. If not, it's added. </p> <p>This uses RAISERROR for the error and I have Validate Type Database on the form for the error being returned.<br> </p> <p>But I noticed that if there's an error with the insert, the end-user sees this full error; not good. </p> <p>How do I change this so if a record already exists, they're notified, but won't see the error if the insert failes, etc. </p> <p>Thanks.. </p> <p><a href="http://dnndev.com/fiddle/fid/692">http://dnndev.com/fiddle/fid/692</a><br> </p>