File Association

[Igor]

Is there a way to associate .sql file with SQLYog?

Right now when I set this up and then double click on the file – it opens SQLYog, but no file in it.

Am I doing something wrong?

I am on 6.0.5 Community Edition.

Thanks.

[peterlaursen]

No you are not doing anything wrong.

Association will start the program, but the statement will neither be exectued nor will the statement be pasted into the editor.

Thank for the idea. We will try to implement as soon as possible!

[Igor]

peterlaursen wrote on Aug 15 2007, 12:54 AM:

No you are not doing anything wrong.

Association will start the program, but the statement will neither be exectued nor will the statement be pasted into the editor.

Thank for the idea. We will try to implement as soon as possible!

Great!

Just to clarify – I am talking about opening the file I double click on, not pasting the statement. Pretty much the same thing you can do now with ctrl+o.

Thanks!

[peterlaursen]

“I am talking about opening the file I double click on, not pasting the statement”

Now what I figured was that if you choose to associate .sql files with SQLyog and doubleclick such file, the SQLyog will open and the content of the file will be displayed in the editor. It SQLyog is allready open then the new file would open in a new tab in the currently selected connection. Do we agree?

The only problem is that no connection is open if the program is not open (and then no Query Tab is open either), but of course we can 'push in between' a connections dialogue.

[Igor]

peterlaursen wrote on Aug 15 2007, 01:08 PM:

“I am talking about opening the file I double click on, not pasting the statement”

Now what I figured was that if you choose to associate .sql files with SQLyog and doubleclick such file, the SQLyog will open and the content of the file will be displayed in the editor. It SQLyog is allready open then the new file would open in a new tab in the currently selected connection. Do we agree?

Yes, though I sometimes run multiple instances of Yog at the same time. But I guess the last one open will be OK. Or you can just launch a new one. Preference?

peterlaursen wrote on Aug 15 2007, 01:08 PM:

The only problem is that no connection is open if the program is not open (and then no Query Tab is open either), but of course we can 'push in between' a connections dialogue.

Yes, either that or (something you may want to implement in the future) just opening the file without having to connect to db at all. Then when you choose to do something with db, such as browse or deploy the stored proc in – you can bring up the connection dialog.

I found this feature missing when I was working offline and still wanted to edit the file in SQL Yog, but I couldn't because it wouldn't open up without a db connection.

I was one of the developers of SQL Station – and we had to deal with exactly the same issues…

Great job on the product!!!

[Author]

Posts