Custom Error Messages in Crystal Version 8

[MattDavies51]

I want to display a custom error message in Crystal(using a dialog box), so in the stored procedure I have been using:

RAISERROR (@VErr, 16, 1) WITH NOWAIT

where @VErr is the error message. However instead of displaying this, Crystal is showing the annoying 'Error Detected by Database DLL' error.

Does anyone know how to do this?

I am using SQL Server 2000 and Crystal Reports 8.

Thanks in advance for your assistance.

 

[synapsevampire]

Since you don't have a programming interface, I'm not sure that it's simple.

You can add error messages to SQL Server, and then they might get passed via ODBC, I've only done this through a customized interface though, so I'm not certain how well just an ODBC driver will hadnle this:

http://builder.com.com/5100-6388-1045786.html

-k