I am working with a file, and like everyone else who has once lost everything he wrote in couple of past hours, I hit CTRL+S every single minute or maybe even more often
The problem is - occasionally (many times a day) SQLnav brings up Save As dialogue like I am saving the file for the first time.
It would be ok, if I just could hit Enter and overwrite the file, but the Save As dialogue has browsed to a completely different folder.
So I have to navigate back where the file actually is saved and then overwrite it.
I cannot reproduce this thing. I just wanted to know if am I doing something wrong or maybe someone else is experiencing this problem?
Has been an issue also on Win 7 (64bit) and SQLnav 6.3. Now on Win 8.1/SQLnav 7.0.1.
Are you saying that the file is opened and saved in your code editor, then you continue doing other operations in Nav, but the save as window just come out all of a sudden, and the location is incorrect?
If so I haven’t met such situations so far, I am wondering that if you have set any short cut key to trigger this save as event. I will continue checking for you.
BTW can you please check the files status from the code editor status bar? the file should be shown as Modified if anything changed, and Ctrl+S will make that status disappear which means your file has been saved successfully. You can keep an eye on that status next time when you meet this problem again.
I reported the same problem in a prior version (6.x?) of SQL Nav, and it was eventually patched. Now I am having the same problem again in 7.0.1. Dangerous problem because you can lose track of where your source code is, or overlay something important.
Don’t know the exact scenario where it occurs, but happens when working on multiple files from different paths/folders at same time. I go back to previously opened file, and when go to save it forgets where it got the file. I then have to manually navigate to where I think it came from and do a Save-As.
“Are you saying that the file is opened and saved in your code editor, then you continue doing other operations in Nav, but the save as window just come out all of a sudden, and the location is incorrect?”
The “Save As” window comes up when I do “CTRL+S”.
No, I have only one shortcut defined and it is “CTRL+SHIFT+Z” (irrelevant).
Yes, the file status is “Modified”, because I have modified it once again. But why the “Save As” dialogue pops-up (?)
It just happened again this morning with and this is important - I have opened only 1 session and only 1 file.
I typed something into the file, saved. Then worked with some other applications. Returned back to Nav, typed something to the same file, CTRL+S, and the “Save As” appeared again.
It happened again and the folder where the “Save As” dialogue is located is the same where the file is saved. So I only had to click Save and Overwrite it.
Thanks Martin and Bill for all the information. SQLNAV-1593 is created for this error. We will investigate this error and will let you know once we fix it.
It happened again and the folder where the “Save As” dialogue is located is the same where the file is saved. So I only had to click Save and Overwrite it.
We figured this issue out, can you please confirm if you did Save when there is result tab displayed? We reproduced it when you made change in the file, then execute the queries in the file, after result tab display, do Ctrl+S will make save as window come out. That is a bug confirmed and we will fix it soon.
Please let us know if this is the situation you met, thanks for your feedback.
Execute some SQL(query) from the file - so that some results are displayed in the grid.
CTRL+S.
Then no - this doesn’t bring up the SAVE AS for me. It is too common scenario. If it popped up after just these simple 3 steps, then it would be completely unusable.