|
64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Sep 2004
Posts: 476 Munich, Germany
Member
|
OP
Member
Joined: Sep 2004
Posts: 476 Munich, Germany |
In the latest 64-bit Release the "AutoSelect statement" feature often selects the current statement wrongly, misses some characters of the statement and the statement cannot be executed then due to ORA-900. This has been occassionally the case in the 32-bit version already too, but I get the impression it happens a lot more frequently in the 64-bit version.
Regards, Berny
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Aug 1999
Posts: 22,218
Member
|
Member
Joined: Aug 1999
Posts: 22,218 |
We'll check it out. I don't assume you can reproduce this?
Marco Kalter Allround Automations
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Dec 2005
Posts: 2,004 Roima Denmark
Member
|
Member
Joined: Dec 2005
Posts: 2,004 Roima Denmark |
I am having the same kind of problems.
In an SQL window with many selects, PLD suddenly always autoselects a specific statement (marked light blue) and even when you press F8 inside another statement, the marked statement is always executed.
You explicitly have to mark another statement before executing it.
I have also seen the behaviour that Bernhard describes: offset errors. When selecting all (Ctrl-A) and copy into another window, only a part of the text is copied. You have to explicitly mark the text that you want to copy.
When I can reproduce, I will report it. The problem is that it often accurs after maybe 1/2 hour of editing in different windows, so it is not easy to reproduce.
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Sep 2004
Posts: 476 Munich, Germany
Member
|
OP
Member
Joined: Sep 2004
Posts: 476 Munich, Germany |
It's not reproducible so far for me in any predictable fashion, but happens annoyingly frequently, sometimes right after opening a larger project, sometimes just after a while of working in such a project. Once it shows offset errors though the only way to execute statements then is either manually selecting the statements or closing and reopening the affected window so that AutoSelect gets recalibrated and works again, at least for a while.
Regards, Berny
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Sep 2008
Posts: 34
Member
|
Member
Joined: Sep 2008
Posts: 34 |
Hello, Sometimes, it happens to me also (32bit version), not very often. D.
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Dec 2005
Posts: 132 Leoben,Austria
Member
|
Member
Joined: Dec 2005
Posts: 132 Leoben,Austria |
I have also seen this happening a couple of times with the x64 version (and no I can not reproduce this on will). This can be seen as something dangerous (e.g. autoselect "decides" to do some update statement instead of the intended select)
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Aug 1999
Posts: 22,218
Member
|
Member
Joined: Aug 1999
Posts: 22,218 |
Marco Kalter Allround Automations
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Sep 2004
Posts: 476 Munich, Germany
Member
|
OP
Member
Joined: Sep 2004
Posts: 476 Munich, Germany |
This misalignment using AutoSelect happens still with the new PSD version 12 as well.
Regards, Berny
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Sep 2004
Posts: 476 Munich, Germany
Member
|
OP
Member
Joined: Sep 2004
Posts: 476 Munich, Germany |
This happens really annoyingly often in v12, a lot more than in v11! I often get this problem right away after opening a project and just editing an SQL window a tiny little bit. Currently there are only the following workaround as far as I'm aware: - Close and reopen the current SQL window
- Manually align and select the current statement before executing.
Both methods are cumbersome and time consuming. As PL/SQL Developer has such frequent problems with misalignment of statements for AutoSelect there should be at least a manual command with keyboard-shortcut to enforce a quick realignment.
Regards, Berny
|
|
|
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
|
Joined: Aug 1999
Posts: 22,218
Member
|
Member
Joined: Aug 1999
Posts: 22,218 |
If you have a reproducible scenario, please let me know.
Marco Kalter Allround Automations
|
|
|
|
|
|