RE: Returns and a space not allowed in Toad

> Very strange but there's definitely a coded instruction that makes it do that whenever the enter key is used.

See View|Options|Editor|Behavior. Click the Auto Replace button. There is an edit box there for "Activation expression" that has the following in it by default.

[;,:=\[\]\(\)\s]

which should actually be... [;,:=\[\]()\s], but...

That expression is a regular expression character class that specify which characters will invoke the auto replace. By default it will invoke auto replace whenever a semicolon, comma, colon, equals, open bracket, close bracket, open paren, close paren, or whitespace character is entered. You can tweak that as needed.

Regarding auto replace in comments. This is a crude feature that is fast because it is dumb. It does not make any assumptions that the replacement may or may not be desirable in a certain location. In order to do this we need to evaluate the syntax tokens and determine if we are within a comment (or string) and abort. This is somewhat fast, but potentially costly in large blocks of code. Whenever any of those characters above are entered we look for an auto replace. If we then had to evaluate where the caret is located we add overhead. Overhead reduces performance. The Editor is often criticized for being sluggish especially with large code. All of these little tweaks add up over time and add to the sluggishness. Feel free to log this in the IdeaPond though if you'd like to see the behavior changed.

A newer feature has been in recent versions of Toad to check syntax as you type. See View|Options|Editor|Code Assist. Any syntax errors are flagged and underlined. If you remove all of the auto replace items that are interfering with your work or disable it completely the syntax parser will show you the errors and you can manually make the replacement or rt-click and make the replacement from there.

Michael

From: [email protected] [mailto:[email protected]] On Behalf Of Jeanne Hiesel
Sent: Wednesday, May 30, 2012 12:39 PM
To: [email protected]
Subject: Re: [toad] Returns and a space not allowed in Toad



I was able to repeat this but I was also able to get around it by not hitting the enter key.

If I typed '-- returns' or 'returns' and then moved to the next line using the mouse and cursor the 's' stays

Very strange but there's definitely a coded instruction that makes it do that whenever the enter key is used.

On Wed, May 30, 2012 at 11:46 AM, oracle8202 <[email protected]<mailto:[email protected]>> wrote:


Whenever I type the word "returns" followed by a space the "s" is deleted, and the word becomes "return". This even happens in comments.

Toad for Oracle 11.5.0.56