Print Thread
Page 1 of 2 1 2
64-bit Release: "AutoSelect statement" feature often selects wrongly
#52868 01/07/16 10:20 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
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
Bernhard S #52880 01/08/16 10:14 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
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
Marco Kalter #52883 01/08/16 10:20 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
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
Claus Pedersen #52919 01/14/16 06:18 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
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
Bernhard S #52920 01/14/16 09:25 AM
Joined: Sep 2008
Posts: 34
C
Member
Offline
Member
C
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
czdavidm #52961 01/22/16 07:10 AM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
Offline
Member
D
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
Dezsoe Kados #52963 01/22/16 10:41 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
We're looking into this.


Marco Kalter
Allround Automations
Re: 64-bit Release: "AutoSelect statement" feature often selects wrongly
Marco Kalter #55735 02/07/17 04:26 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
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
Bernhard S #55880 02/16/17 06:36 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
This happens really annoyingly often in v12, a lot more than in v11! cry
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
Bernhard S #55884 02/16/17 10:08 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
If you have a reproducible scenario, please let me know.


Marco Kalter
Allround Automations
Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.040s Queries: 16 (0.013s) Memory: 2.5605 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-04-29 07:03:53 UTC
Valid HTML 5 and Valid CSS