Retour
-
Titre
Can Toad highlight more specifically the line and/or position of where an error is located in a script? -
Description
Is there a way to get Toad for SQL Server to highlight/pinpoint the specfiic location of an error found in the code?
Example:
Error encountered in script, "Error converting data type varchar to float".
Line 1: select case when (COL1int = 22)
Line 2: then col1int when (COL1int = 21)
Line 3: then convert (float, COL4char)
Line 4: else ...In this case COL4char is cannot be converted. Toad will highlight the error as Line 1 Position 0, instead of what may be expected as Line 3, or even more specifically Line 3 Position 21.Can Toad pinpoint the error and direct the user specifically to Line 3 at the least?
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.