"Comment Block" (Ctrl + B) option only comments every second or every other line (alternating lines) when View | Toad Options | Editor | Display | "Persist selection when using navigation keys" option is checked. The Comment Block functionality does not work properly.
Example:
1) Go to View | Toad Options | Editor | Display | checkmark "Persist selection when using navigation keys"
2) Type the following code in Editor and Highlight (Select All) the whole block of code
SELECT *
FROM dual
WHERE 1=2
OR 2=3
;
3) Perform a "Comment Block" command by pressing Ctrl + B
The result is:
--SELECT *
FROM dual
--WHERE 1=2
OR 2=3
--;----
4) If I uncheck the "Persist selection when using navigation keys" option, the Comment Block command works correctly
--SELECT *
--FROM dual
--WHERE 1=2
--OR 2=3
--;
WORKAROUND:
Go to View | Toad Options | Editor | Display and uncheck "Persist selection when using navigation keys" check box.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
Issue is fixed in Toad for Oracle Beta 10.
