Toad World® Forums

TOAD 13/14 - Leading tabs in the editor truncate the sql statement by 3 characters

This here is something that bothers me for quite a while now. I think it was introduced with Toad for Oracle 13.3 and it's still there in 14.2:
In the Editor, a sql statement may be truncated by its last 3 characters, if there are 3 or more leading tabs.
So, for instance:

select * from dual where 1=1234;

yields (of course) no result, whereas

[tab][tab][tab]select * from dual where 1=1234;

actually gives a result!

Took me a while to find out that this was only due to the leading tabs. Until then I always used TOAD 13.1.1 if I wanted to executed SQL queries in the editor...

Or is it just me? :slight_smile:

I can reproduce this, so it's not just you. I did notice that if I switch the tab mode to spaces vs tab, in the Toad Options, then the issue goes away. Could be a work-around until Dev fixes the issue in an upcoming release. Hope this helps for now.

1 Like

That could be a work-around, yes. Thank you, Gary.

This will be fixed in the next Toad beta. If you are on 14.2, you can get the current beta here. The beta with this fix for this will come out on July 26th.

1 Like

Excellent, John. Thank you! :slight_smile:

You're welcome. Please try it out and let me know how it goes.