Well, it's hard to say because we haven't identified the exact defect that you're having, but try version 13.3. https://support.quest.com/toad-for-oracle/13.3. Get the same bitness (32/64) as your current version of Toad so you can use the same Oracle client.
Different Toad versions can be installed side-by-side. So 13.3, 14.0 and beta can all be installed without problem. They each keep their own copy of settings, so you don't have to worry about any conflicts there.
Yes, I'd call that a bug. I tried to reproduce it but unfortunately, I could not.
I have a few ideas:
Go to Options -> Editor -> Behavior. Uncheck "Display SQL errors in popup dialog". Does that help?
Scroll up to my reply on Nov 20 and try those steps.
Try the beta. Toad for Oracle 14.1 Beta (Do not uninstall your 14.0 version. The beta requires the latest official version to also be installed.)
If those don't fix it, I'd like to get a copy of your user files folder so I can try to reproduce it. But I am hopeful that it's already fixed in beta. We did solve a few lockup issues, but admittedly, this exact issue does not come to mind.
I did try "Uncheck "Display SQL errors in popup dialog" already, no luck. I was trying to find settings where it highlights text to see if I could change it to not highlight. But TOAD 13 no issues and it looks exactly the same as my example. The XXX will be highlighted, I hit enter and the XXX is deleted. This is in 13.3.0.181. In 14 it seems like it is trying to do something with the XXX and gets hung up.
Oh, it gets hung after you hit Enter (at first I thought you were hitting enter to make the dialog go away). OK, yes, I can reproduce that and I believe that one is fixed in beta.
I can also easily reproduce the issue with these commands (14.0.75.662, 64-bit).
But in my case I am not getting any dialog box, where to click OK (P3 - dismiss the dialog)
Having that said, I will press enter and crashes.
So quite a lot of (3 known to me) "toad crashing" issues with this version (14.0.75.662, 64-bit)
I don't have time at the moment to try beta, but sounds like you are pretty confident it is fixed so I will just wait for the next official update, thanks!
I just upgraded to 14.0 and have had nothing but issues with Toad hanging. Had to force restarts at least 3 times so far this morning.
Enough is enough! Clearly this version is not fit for purpose so will be reverting back to 13.3. That will teach me for upgrading to a newer version when it is first released.
I think more testing of products before releasing is require to avoid customer disappointment like this.
Sorry 14.0 caused lock ups. I believe those are fixed in the current beta, and they seem to be fixed for @raul.kaubi too.
I hear you about quality. My goal has been to get Toad as solid as possible. I know users are tired of problems, and I want to fix them. We do perform a lot of testing, but it's impossible to predict everything that could cause a problem. I can tell you that I've been primarily focused on bug fixes for the past few versions.
Please try the beta. Toad for Oracle 14.1 Beta. You have to keep 14.0 installed to run the beta, but you can also keep 13.3 installed too. They each keep their own copy of settings, and run completely independent of each other.
I understand Toad is a huge application and there are many pieces of functionality that could potentially cause issues, but on all three occasions this morning I was editing and running SQL in the editor. It really doesn’t get much simpler than this and this should be bread and butter for Toad.
I’m not interested in using a Beta as I don’t have enough spare time to “test” Toad. To be productive I need a tool that just “works”, so I have reverted back to 13.3 and I won’t be planning to upgrade again for some time.
Think I've found another bug. Fresh install and new workstation. 14.0.75.662
Day one, I started editing a long SQL statement with multiple sub selects and unions. On folding the inner sub selects so I could see all of and work on the outer group by's etc. On mouse wheel scroll, toad would die. Have experienced editing test SQL code and package implementation.
Fold code, mouse scroll, toad dies.
Would appreciate to know, if you can reproduce, if this is fixed in beta before I decide on beta or installing older 13.3
I have been experiencing the same issues and found that disabling the "Auto Replace" prevents Toad from crashing in this scenario. Instead when you press enter, it just deletes the invalid table name.
