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!