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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05