HI, I have a general question on the correct way to do a lookup/validation. I have been using a simple "Select cust_id from customer where cust_id = myvar". Where myvar comes from a routine that was saving a record and making sure I didn't violated a unique key (user entered). But I actually had two users have a conflict where an error message was returned from the SQL server. IOW I had two users that attempted to save a record and both passed the select statement and continued to save (of course only one actually saved the record). So what's the recommended way to validate the unique key prior to attempting to save the record? I was thinking that a SP might work where it would return a false/true which would be a little faster and therefore limit the conflict. Or may the SP could add a record with the key field and then return the record number. Or does everyone just attempt the save and handle the error message?
