I support a web application that contains SQL statements which are passed to a Teradata database. When I need to debug a SQL statement, I copy the statement from the variable and paste it into a Toad Data Point editor.
I can type a SQL statement into a Toad Data Point Editor and successfully format the statement, but when I paste a SQL statement that was copied from Visual Studio, the Formatter will not format the statement.
I do notice that when I paste from Visual Studio into the Editor, the Select clause is preceeded by a collapse/expand box (i.e a square w/ a dash inside of it), but I only see this when I paste code into the Editor from Visual Studio. I have copied/pasted SQL statements from Notepad into the Editor and the Formatter works as expected. I have even tried pasting code (copied from Visual Studio) into NotePad, then copying the code in NotePad and pasting it into the Editor, but the Formatter will not format the code.
This extremely frustrating, since most of the SQL statements are rather lengthy and it takes too much time to manually format the code in the Editor.
Would somebody be able to help me understand what is going on?
Thanks in advance!