Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Save Query? prompt

djdjohnson's profile image djdjohnson posted 9 years ago in Feature discussion Permalink
Is there any chance we could get an option to turn off the Save Query prompt when closing HeidiSQL?

My computer has been prevented from shutting down or logging off more times than I can count because HeidiSQL is asking if I want to save a query (no, I don't... ever) when it is being closed.
ansgar's profile image ansgar posted 9 years ago Permalink
Just press Ctrl+W for clearing/resetting the editor before closing HeidiSQL. No other way I'm afraid.
djdjohnson's profile image djdjohnson posted 9 years ago Permalink
I'm going to make another request for this. I have had my laptop battery die on several occasions because I thought I was shutting the computer down, only to find that there was a HeidiSQL window open that I didn't know about and it was asking me to save a query that I didn't want to keep, and thus preventing the computer from shutting down. Generally speaking, if I want to save a query, I'll do it myself, and the reminder to save it by HeidiSQL when shutting down is extremely annoying. Especially on Windows 7, where the window is obscured by the "Waiting for applications to close" screen so you can't even see the prompt or click on it to get it to go away.

It also gets in the way when updating the software. When I have multiple HeidiSQL windows open (always) and I try to install an update, every window asks me to save the query, and the updater continually beeps at me every second until every prompt is acknowledged and cleared.

Can you please add an option to turn off the prompt to save queries?
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Rapid-eraser's profile image Rapid-eraser posted 9 years ago Permalink
djdjohnson++ I would recommend saving warning to be optional and move to options for user to decide what to do with itsmilehappy
ansgar's profile image ansgar posted 9 years ago Permalink
Think that's what djdjohnson meant when he said "Can you please add an option...".

Sounds reasonable.
djdjohnson's profile image djdjohnson posted 9 years ago Permalink
Yes, I'm asking for the option. I realize that a lot of people would prefer to be asked to save queries, but there are probably a lot of people like me that remember to save our queries on our own and the reminder just gets in the way.
Code modification/commit from ansgar.becker, 9 years ago, revision 3544
Make prompt to save modified SQL text customizable. See http://www.heidisql.com/forum.php?t=6373
ansgar's profile image ansgar posted 9 years ago Permalink
r3544 finally makes this prompt customizable. See Tools > Preferences > Miscellaneous > "Prompt to save modified files on tab close"
Rapid-eraser's profile image Rapid-eraser posted 9 years ago Permalink
you are the best :)
djdjohnson's profile image djdjohnson posted 9 years ago Permalink
It works perfectly. Thank you, thank you!!!
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
byman64's profile image byman64 posted 2 years ago Permalink

Hey there, I a new HeidiSQL m8.

I loose my complex query not fully saved :-( I just closed the query tab and I didnt get any confirmation.

I was searching a solution and ansgar talk about Miscellaneous options...I dont heve that tab... This one it's an old post but I hope someone will read my new post and help me

thanks

byman64's profile image byman64 posted 2 years ago Permalink

Hey there, I a new HeidiSQL m8.

I loose my complex query not fully saved :-( I just closed the query tab and I didnt get any confirmation.

I was searching a solution and ansgar talk about Miscellaneous options...I dont heve that tab... This one it's an old post but I hope someone will read my new post and help me

thanks

I forgot to say: I closed the Query Tab using Ctrl-W

ansgar's profile image ansgar posted 2 years ago Permalink

Well, the tab was renamed and/or moved - no wonder after 8 years.

See screenshot for what I meant in 2010.

1 attachment(s):
  • prompt-save-modified-sql

Please login to leave a reply, or register at first.