Print Thread
SQL Window "Save as Standard Query" fails without error
#56014 03/01/17 04:12 PM
Joined: Oct 2005
Posts: 587
Belgium
Roeland Offline OP
Member
OP Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
When I want to store my query using the "Save as Standard Query" of a SQL Window, and I use some unallowed characters, PL/SQL Developer fails to mention this...

I typed in the query name something with ":" and the query was not saved.

I did some more tests, but have now the problem that I don't know how to remove my tests?
Shift-Del should do the thrick, no?

PL/SQL Developer 12.0.1.1814 (64 bit)

Re: SQL Window "Save as Standard Query" fails without error
Roeland #56018 03/02/17 10:09 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
You can only remove the files from the following directory:

%APPDATA%\PLSQL Developer 12\Standard Queries

We'll look into the error situation.

Last edited by Marco Kalter; 03/02/17 10:10 AM.

Marco Kalter
Allround Automations
Re: SQL Window "Save as Standard Query" fails without error
Marco Kalter #56027 03/02/17 03:48 PM
Joined: Oct 2005
Posts: 587
Belgium
Roeland Offline OP
Member
OP Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
I have noticed that those files are stored into
%APPDATA%\PLSQL Developer\Standard Queries instead of
%APPDATA%\PLSQL Developer 12\Standard Queries?

Is this a bug or a configuration issue?


Roeland
Re: SQL Window "Save as Standard Query" fails without error
Roeland #56034 03/03/17 09:50 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
I tested this, and they are saved under "PLSQL Developer 12" for me. Version 11 stored them under "PLSQL Developer". Can you verify?

Your original error report seems to be limited to the ":" character. When saving a file with a ":" in the name, it is truncated at the ":" position. For other invalid characters (such as "*" or "?") an error is displayed.


Marco Kalter
Allround Automations
Re: SQL Window "Save as Standard Query" fails without error
Marco Kalter #56042 03/03/17 12:17 PM
Joined: Oct 2005
Posts: 587
Belgium
Roeland Offline OP
Member
OP Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
[quote]I tested this, and they are saved under "PLSQL Developer 12" for me. Version 11 stored them under "PLSQL Developer". Can you verify?[/quote]
I checked again, and the last change in the Standard Queries is from 19/10/2016 in the "PLSQL Developer 12" directory, while all my changes are stored into the "PLSQL Developer" one.
I then looked at the other directories where "PLSQL Developer" is used rather then "PLSQL Developer 12":
  • PFInfo
  • Red Gate Plug-In, allthough I don't use it

I checked the files, and this file is also updated in the wrong directory:
  • PLSRecall.dat




Roeland
Re: SQL Window "Save as Standard Query" fails without error
Roeland #56049 03/04/17 10:59 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
Could it be that you have explicitly set the directory locations for these files in the preferences? Check the following preference pages:

Files > Directories
Files > Backup
Tools > Recall Statement

Last edited by Marco Kalter; 03/04/17 11:29 AM.

Marco Kalter
Allround Automations
Re: SQL Window "Save as Standard Query" fails without error
Marco Kalter #56062 03/06/17 02:16 PM
Joined: Oct 2005
Posts: 587
Belgium
Roeland Offline OP
Member
OP Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
That solved it. Thx Marco


Roeland

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.025s Queries: 14 (0.007s) Memory: 2.5257 MB (Peak: 3.0423 MB) Data Comp: Off Server Time: 2024-05-14 01:05:46 UTC
Valid HTML 5 and Valid CSS