Currently No Way To Close Open Script File

[glenbrydon]

Hi,

Excellent product overall, but when I open a SQL script file, there is no way to close it. There is a clear command for clearing the script entry field, but doing this is dangerous because if one mistakenly does the save command, the last script read in will be wiped out!

Your product is functionally equivalent to a text editor, despite the fact that the text is a program text, which can be evaluated. Most IDEs properly do the following with files:

1) Allow for opening a new file, it remembers the name for doing a subsequent save operation

2) Allow for closing same. This means the name goes away and the save function is now disabled because there is nothing to save.

3) If you have modified the text of the last file opened and did NOT subsequently save it, and then you decide to exit the application or clear the buffer, the program should warn you that you are about to potentially lose your program! SQLyog does not currently have such a concept and will exit without giving any warning at all.

If nothing else, you should add a close option to the file menu. selecting this option should clear out the currently remembered filename so that you will not inadvertently wipe out the last file you did open.

Obviously, my use of CLEAR in the absence of CLOSE is the main problem that I have experienced by wiping out my last opened file. CLEAR really isn't the problem per se, given that I could simply select all the text and remove it, but not having a way to clear the current filename is the problem.

Thanks and good luck!

[glenbrydon]

I just realized that I wasn't running the lastest version, so I upgraded to 5.0. Then when exploring that new version, I noticed that you now support the ability to have multiple scripts open at the same time. While there is no CLOSE option in the file menu, you do have the X icon in the upper-right-hand corner of the script window, which does do the close function I was speaking of.

I also tried making a change to one of my open script windows and then tried to either close that window or exit the application and low and behold, it now does ask me if I don't want to write out the latest version of the script (yeah!).

So, in conclusion, I have learned a valuable lesson. Before complaining, check to see if I'm using the most up to date version. As they say, great minds think alike!

Thanks so much,

Glen

[Author]

Posts