Multiple files in a single instance

[Felipe Guimar]

Hello !

After updating my plsql from version 12 to 13.0.0.1883, I am no longer able to open multiple files in the instance already opened, through windows explorer.

When you double-click the file, a new instance of plsql developer opens.

I linked the ".sql" extension in windows to the application.
I also registered extensions through preferences within plsql developer.

But none of the solutions above worked.

Can someone help me ? I use Windows 10.

 

[Marco Kalter]

I tested this and it works fine for me for PL/SQL Developer 13.0 on Windows 10. Double-clicking on a PL/SQL Developer file opens the file in the currently opened PL/SQL Developer 13.0 instance.

When registering the extensions in the preferences, can you make sure that all extensions are checked in the list? After registering, can you reboot the PC and open the extension registration form again? All extensions should now be checked, and all should show (PL/SQL Developer 13) as the registered application. If this is all correct, please retry opening files again in the Windows Explorer.

 

[Felipe Guimar]

@ Marco, thank you.

I did all the procedures, including uninstalling the application, removing the .sql association of windows with plsql developer 13, and installing again (registering the file types to plsql developer) and it still did not work.

I installed version 12 again to test, and with it, the files open in a single instance.

But the version has got great features, I do not want to give it up

:/

 

[Felipe Guimar]

Has anyone had this problem?

 

[mobailey]

As per my own thread - I've had problems associating file types with Version 13 too. Like you, I installed version 13 onto a PC which already had ver 12 installed.

re: "When registering the extensions in the preferences, can you make sure that all extensions are checked in the list?"

Thinking about it, in case it's relevant: I selected MOST of the extension types in the list, but not ALL.

"After registering, can you reboot the PC"

I didn't try rebooting straight after registering the extensions. Although I did reboot at some points whilst trying to get it to work.

"and open the extension registration form again? All extensions should now be checked, and all should show (PL/SQL Developer 13) as the registered application."

The form did state they the extensions were associated version 13 - but that didn't mean that Windows believed they were.

Hope there's something here that helps.

-mobailey

 

[Fred6]

I have also upgraded from PL/SQL Developer from 12 to 13 - and I am literally going out of my mind with this problem.

It is the only app I have ever seen do this. (and I have seen it in previous version where is used to crash unless you "ran as administrator" to do the associations)

I have logged a support request with ARA but they have told me exactly the above which has not worked for me at all.

I have:
1. done the above
2. de-installed 13
3. removed all entries I could find in the registry editor containing "allroundautomations"
4. rebooted
5. re-installed 13
6. associated ALL files
7. rebooted again

and STILL a new copy of the application opens every time I select an associated file in Explorer (the correct icons are showing next to the explorer files)

Without over dramatising this, I am sadly going to be forced to drop this product unless a solution can be provided.

 

[Fred6]

Following on from the above:

I have subsequently uninstalled 13.

Then I have gone through registry searching for

pl sql
pl/sql
allroundautomations

clearing out any entries I can find.

I have wiped out my old 12 profile and my new 13 profile.

I have rebooted, re-installed, associated all file types in the 13 configuration options.

I have rebooted again

Now when I look in Explorer, even though the associations have been done above, no associations show in Explorer.

I do the association in Explorer, then it shows the file type extension as being associated with PL/SQL Dev 13 - but each time a file is clicked, a new copy of 13 opens.

After weeks of frustration and hours of trying to sort this out I give up.

I have uninstalled 13 => re-installed 12, done exactly the same registration, rebooted and everything works fine.

My conclusion: this is either an issue with 13 itself, or an issue with poor upgrade housekeeping (as I note that others hitting this issue have upgraded from 12)

I will stay on 12 until allround automations resolves this issue and updates here that it has been done.

 

[Felipe Guimar]

Unfortunately I am living with Eero until it is corrected.
Until then, I need to "drag" the files to the already running plsql window

 

[Claus Pedersen]

A hint, you can also copy-paste files into PLD:

• Use Alt-Tab to change to e.g. Windows explorer
• Use Ctrl-C to copy your file
• Use Alt-Tab to switch back to PLD
• Use Ctrl-V to paste and open the file in PLD.

But I agree that just opening the file in explorer should open the file in the same PLD instance, that is already open.

 

[Marco Kalter]

Can you download the following fix?

32 bit
64 bit

After installation, go to Configure > Preferences > Files / Extensions, press the "Register filetypes" button, select the extensions you want to associate with PL/SQL Developer, and press "OK". Check if double-clicking a file will now correctly open the file in a new or existing PL/SQL Developer 13.0.1 instance.

 

[ChrisPlsql3000]

I had the same problem (on Windows 7).
Updated from Version 12 to 13, but a double click in windows explorer alsways started the Version 12 developer. I deinstalled that old version.
After that step, Windows was not able to start plsql dev 13 by "open with" function. I checked the registry and found out that there are bis differences between 12 and 13.

Old entry:
[HKEY_CLASSES_ROOT\PL/SQL Developer 13]
"FileTypes"="fnc

prc

trg

pck

typ

spc

bdy

tps

tpb

jsp

s

tst

sql

rep

pdc

pdd

prj

dsk

"

New entry (copied from 12):
[HKEY_CLASSES_ROOT\PL/SQL Developer 13]
"FileTypes"="fnc

prc

trg

pck

typ

spc

bdy

tps

tpb

jsp

s

tst

sql

rep

pdc

pdd

prj

dsk

"
@="PL/SQL Developer 13 file"
"EditFlags"=hex:00,00,00,00

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\DefaultIcon]
@="C:\\Program Files\\PLSQL Developer 13\\plsqldev.exe,1"

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\Shell]

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\Shell\Open]

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\Shell\Open\Command]
@="C:\\Program Files\\PLSQL Developer 13\\plsqldev.exe /dde"

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\Shell\Open\ddeexec]
@="[Open(\"%1\")]"

[HKEY_CLASSES_ROOT\PL/SQL Developer 13\Shell\Open\ddeexec\Application]
@="PLSQLDEV"

After that change, the windows "open with" window is able to find plsql dev 13. And all files will be opnened by the running instance. Everything is fine!

 

[Felipe Guimar]

@Marco Kalter.

Thank you ! It's working now !

 

[Fred6]

13.0.2 fixed the problem for me immediately.

Thank you to Marco and the Allround Automations team for sorting this out!