Print Thread
Page 1 of 2 1 2
AutoSelect statement - Setting
#53867 08/12/16 09:00 AM
Joined: Jun 2007
Posts: 61
Sheffield
I
Member
OP Offline
Member
I
Joined: Jun 2007
Posts: 61
Sheffield
Over the last two updates, I have had an issue with this setting whereby if I have multiple sql statements (terminated by semi-colons) - then no matter which statement has been selected, it will always run the top most query unless I select/highlight the required statement fully and then execute.

The only way I can stop this is to copy the contents of the sql window to a new window and then it seems to work.

Just slows things down a little.
Is there a fix in the pipeline, or something i'm doing wrong? Another setting perhaps?
Thanks
Matt.

--
PL/SQL Developer
Version 11.0.6.1776
01.105297 - 5 user license
Service Contract: 01/01/2019
Windows 7 (64-bit) Build 7601 (Service Pack 1)

Last edited by IncredibleMrT; 08/12/16 09:01 AM.
Re: AutoSelect statement - Setting
IncredibleMrT #53870 08/12/16 09:29 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
What is the setting of your "Auto Select Statement" preference (Tools > Preferences > SQL Window)?


Marco Kalter
Allround Automations
Re: AutoSelect statement - Setting
Marco Kalter #53872 08/12/16 09:42 AM
Joined: Jun 2007
Posts: 61
Sheffield
I
Member
OP Offline
Member
I
Joined: Jun 2007
Posts: 61
Sheffield
Hi,
It's ticked.

The problem isn't always there - I can be working quite happily without issue and then all of a sudden it will stop auto selecting.
It doesn't happen to every window, but when it does, it can be almost as soon as I have 2+ queries or it can be after hours of use.
It's like something is clearing the setting within the scope of this one window, or it's just forgetting its set.

Re: AutoSelect statement - Setting
IncredibleMrT #53874 08/12/16 06:39 PM
Joined: Feb 2003
Posts: 126
Portland, OR. USA
F
Member
Offline
Member
F
Joined: Feb 2003
Posts: 126
Portland, OR. USA
That is part of the behavior that I am experiencing.
I have reported this so many times.

@IncrefibleMrT Try select all the queries when this happen and paste it in another editor (not pl/sql developer tool). Let me know if the queries are copied or not.

That is the second part of my problem.
1. Autoselect stop selecting where the cursor is.
2. The cause of number 1 is because the editor even is showing multiple queries, in reality only the one is there. Even if you save that screen, close it and then reopen you will loose some queries.

Let me know if you experience the same.

Re: AutoSelect statement - Setting
fidelfs #53879 08/15/16 08:02 AM
Joined: Jun 2007
Posts: 61
Sheffield
I
Member
OP Offline
Member
I
Joined: Jun 2007
Posts: 61
Sheffield
Yes, fidelfs, I have noticed that too, that queries disappear after this issue manifests itself.
And yes, when it happens, and I try to copy them - sometimes they are all there and sometimes not.

Re: AutoSelect statement - Setting
IncredibleMrT #53885 08/15/16 02:33 PM
Joined: Feb 2003
Posts: 126
Portland, OR. USA
F
Member
Offline
Member
F
Joined: Feb 2003
Posts: 126
Portland, OR. USA
I have been chasing allroundautomations for this bug. I know is hard to replicate but it is happening and it is just not me.

It was suggested that might be my environment, but if this is happening to another person and environment then it is not a localized problem.

They need to address this soon.


Re: AutoSelect statement - Setting
fidelfs #53887 08/15/16 10:20 PM
Joined: Feb 2006
Posts: 619
Sao Paulo, Brazil
G
Member
Offline
Member
G
Joined: Feb 2006
Posts: 619
Sao Paulo, Brazil
Is any MS Office program open? Its clipboard manager has already caused me some trouble.


There are 10 types of people: those who know binary and those who don't.
Re: AutoSelect statement - Setting
Gustavo #53895 08/16/16 08:06 PM
Joined: Feb 2003
Posts: 126
Portland, OR. USA
F
Member
Offline
Member
F
Joined: Feb 2003
Posts: 126
Portland, OR. USA
Yes, but the problem happens even when ms open is not open.
Or when it is open the problem doesn't happen.

The problem is this issue has too many replies and they won't look at it anymore.

This bug keeps going and going. It causes serial problem it is not a small issue.

Re: AutoSelect statement - Setting
fidelfs #53913 08/22/16 05:12 PM
Joined: Feb 2003
Posts: 126
Portland, OR. USA
F
Member
Offline
Member
F
Joined: Feb 2003
Posts: 126
Portland, OR. USA
I meant to say this "happens even when MS Office is not open"

Re: AutoSelect statement - Setting
fidelfs #53929 08/26/16 11:41 PM
Joined: Jul 2016
Posts: 8
J
Member
Offline
Member
J
Joined: Jul 2016
Posts: 8
Also experiencing this issue.

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.033s Queries: 15 (0.013s) Memory: 2.5619 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-18 18:07:09 UTC
Valid HTML 5 and Valid CSS