Multiple Instances in Double Click

[Tarquino]

Hi,

PLSQL Dev always open a new instance when I double click a file associated to it.
Is there any preference to avoid this?

Thanks,
Alexandre Tarquino

 

[Gustavo]

You can drag the file to an open instance. Or you could drag the file to PLSD button in the task bar and then drag to that instance.

 

[Marco Kalter]

It may also depend on your exact PL/SQL Developer version. Can you let me know?

 

[Tarquino]

Marco,
My version is 7.1.5.1396

Gustavo,
It's so annoying to drag a file to a opened window. The behavior I expected is to reuse the current window to new files.
I saw that you are from S

 

[Gustavo]

I got used to dragging files. I do it for rtf files and other extensions, as I don't have admin privileges here, so program extensions and PLSD are not associated.
BTW, I'm from Salvador, I just live (sadly) in S

 

[Tarquino]

Marco,

Any sugestion?

Thanks,
A.Tarquino

 

[Marco Kalter]

Perhaps you can go to Tools > Preferences > Files/Extensions, press the "Register Filetypes" button, press "OK" in the subsequent dialog, and try again?

 

[Tarquino]

Marco,

Didn't work.

But I have the solution and you can add this feature if you want in the near versions.

In the registry go to HKEY_CLASS_ROOT\PL/SQL Developer Key;
Navigate to Shell->Open and rename the key name ddeexec-disable to ddeexec;
Inside ddeexec navigate to Application and change the value DDLHOST to plsqldev
Done!

Now my PL/SQL Dev reuse the same window for all the file types associated to it.

Caution: it's better to backup the registry before the modifications.

Regards,
Alexandre Tarquino

 

[Pitcher]

Hello.

In the registry go to HKEY_CLASS_ROOT\PL/SQL Developer Key;
Navigate to Shell->Open and rename the key name ddeexec-disable to ddeexec;
Inside ddeexec navigate to Application and change the value DDLHOST to plsqldev

Does not work with 7.1.5.1398 here

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open\ddeexec\Application]
@="PLSQLDEV"
"DDLHOST"="C:\Programme\PLSQL Developer\plsqldev.exe"

It'll be renamed back to 'ddeexec-disabled' everytime I close plsqldev.

Any ideas?

 

[Pitcher]

Anybody there?!
It could not be as difficult to find a solution for this problem.

 

[Marco Kalter]

What is your Windows version?

 

[Pitcher]

It is Windows XP with SP 2 installed.

Thanks for your Feedback.

 

[Marco Kalter]

That is what I have too, and it works fine here. A first double-click opens a PL/SQL Developer instance. A second double-click opens the file in the same instance.

Can you check if the HKEY_CLASSES_ROOT\PL/SQL Developer section looks like this?

[HKEY_CLASSES_ROOT\PL/SQL Developer]
@="PL/SQL Developer file"
"FileTypes"="fnc..."

"EditFlags"=hex:00,00,00,00

[HKEY_CLASSES_ROOT\PL/SQL Developer\DefaultIcon]
@="U:\plsqldev\plsqldev.exe,1"

[HKEY_CLASSES_ROOT\PL/SQL Developer\Shell]

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

[HKEY_CLASSES_ROOT\PL/SQL Developer\Shell\Open\Command]
@="\"U:\plsqldev\plsqldev.exe\" \"%1\""

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

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

 

[Pitcher]

Yes, it does

[HKEY_CLASSES_ROOT\PL/SQL Developer]
@="PL/SQL Developer file"
"FileTypes"="pck
sql
"

[HKEY_CLASSES_ROOT\PL/SQL Developer\Shell]

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

[HKEY_CLASSES_ROOT\PL/SQL Developer\Shell\Open\Command]
@="\"C:\Programme\PLSQL Developer\plsqldev.exe\" \"%1\""

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

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