The table in SQL Server has a unique index on a field. When I attempt to add a record with a duplicate value in this field, the SP correctly does not save the record. However, in my form, it looks like the save succeeded and no failed save message occurs. When does the SP need to return so that I can give the user the proper feedback?

TIA

I figured out what the problem was. My husband was handling the errors internally and logging them to a table and simply returning -1. When I told him to change that and just allow the SP to raise the exception, everything started working as I expected it to.