Strange RAISERROR Behaviour
Posted: Thu 27 Dec 2007 10:08
I am using Delphi 5+4.30.0.13 version of SQL Server Data Access Components.
I develop code on a VM Win2K machine, and my users generally use XPs.
Much of the functionality of the system is in stored procedures and controlled by triggers.
Now I have a problem: when a trigger raises an error, the stored procedure also may report another error (Null value eliminated etc). On the development platform, both errors are shown on a dialog box.
On production platform, only the last error is shown, which is useless.
I am lost. What shall I do?
Edit: problem happens when I connect with DBConnection.Provider = prAuto. When I connect with prSQL, it works as expected. But I do not know what will not work in this case.
I develop code on a VM Win2K machine, and my users generally use XPs.
Much of the functionality of the system is in stored procedures and controlled by triggers.
Now I have a problem: when a trigger raises an error, the stored procedure also may report another error (Null value eliminated etc). On the development platform, both errors are shown on a dialog box.
On production platform, only the last error is shown, which is useless.
I am lost. What shall I do?
Edit: problem happens when I connect with DBConnection.Provider = prAuto. When I connect with prSQL, it works as expected. But I do not know what will not work in this case.