That's why I was mining for more information, to ascertain whether he meant client-side error messages or server-side error messages. I think he's referring to handling the message on the VFP side, but your post is great information if you are using a data services tier via stored procedures.

>If you're using constraints, you cannot change the message the SQL Server generates. If you want to have SQL Server return a customized error message, you'll have to enforce the rule with a trigger and return an error message with the RAISERROR command.
>
>If you want to continue using constraints, you'll have to intercept the error message and translate it into something more user-friendly.
>
>-Mike