![]() ![]() press Alt-O -> the statement is collapsed in one line.Then in the editor, anywhere in your SQL statement Click in the "Press shortcut keys:" and press Alt-O.In the list below, select: Edit.ToggleOutliningExpansion.In the "Show commands containing:" box, enter: Outlining.Tools -> Options -> Environment -> Keyboard. ![]() Only if you do that the F9 button works as expected, executing the current statement. ![]() Unlike Oracle, you have to separate statements in SQL Server with the keyword GO after each statement. ![]() I asked this issue in toadss mail group and got the answer. I think TOAD is the best querying tool ever, but the lack of this feature really annoys me too. I wanted to search for it in the user support group (toadss(at)) but yahoo has the stupidest search facility ever! It can't even find the keyword "toad" in the toad mail group, DOH! I tried it million times but it simply executes the whole script. If an error occurs during statement execution, an error message displays, allowing you to either ignore the error and continue or to abort execution. Note: Toad considers "adjacent" all statements (including comments) separated from the cursor or from each other by fewer than two blank lines. You can select the portion of the statement by placing the cursor within or adjacent to the statement, or by selecting the statement. It is really annoying that TOAD does not hold to what it promises:įrom TOAD help: a portion of a statement, which can contain one or more statements. ![]()
0 Comments
Leave a Reply. |