When you have an error in code, Toad normally displays the error message and automatically displays the "Message" tab at the Results panel; however, with conversion failed errors, Toad displays the error but does "NOT" take you to the Message tab automatically.
Here an example of a conversion error that does not get automatically displayed:
SQL Server Database Error: Conversion failed when converting the nvarchar value 'hello' to data type int.
WORKAROUND: None
STATUS: Waiting for fix in a future release of Toad for SQL Server
1. Create these tables
CREATE TABLE [dbo].[BDSPRV] ([SPRVSNBR] int NULL)
INSERT INTO dbo.BDSPRV (SPRVSNBR) VALUES (1)
CREATE TABLE [dbo].[FilteredAccount ] ([accountnumber] nvarchar(20) NULL)
INSERT INTO dbo.[FilteredAccount ] (accountnumber) VALUES ('hello')
2. Run the following query in Toad for SQL Server:
SELECT * FROM BDSPRV SrcAcc, FilteredAccount FA where SrcAcc.SPRVSNBR = FA.accountnumber
3. Notice that in Toad for SQL Server 5.7, you are NOT taken automatically to the Message tab.
