I have an application in Builder Portal 8.1 that has a sql table with a unique constraint on two columns. If the user enters the same values that have already been entered for this pair of fields, they receive an error in the application.
The builder logs show that this is occurring as I want with the insert being unsuccessfully and throwing the error - Violation of UNIQUE KEY constraint 'UNIQUE_Table'. Cannot insert duplicate key - which is exactly what I want.
However, on the user view, they see "Error Saving Record". I would like to override this error message with something more user friendly and instructional. Can I do this within Builder or is it something SQL Server is sending?
I tried to create a Business rule within Builder to do this same thing (without adding the unique constraint in the sql table), but could not see a way to do this.
Thank you for any advice.
