In SQL Server you can do custom error messages with Raiserror. Do you have something similar in Firebird?
>>Why don't you validate data on front end to avoid the error?
>
>I was hoping the back-end can do this better.
>
>
>>Why do you refresh the form instead of handling the error?
>
>This is where the CodeBook comes in and as there are no error number attached to this else I was hoping to handle this in the error routine or something similar.
>
>Hope I have made sense. Thanks.
If it's not broken, fix it until it is.
My Blog