Author |
Message |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
Sql Editor - Doesn't retain the previous open files |
|
Hi,
I keep having to reopen some (not all) of the files in Sql Editor each day.
At the end of the day, I shut down with File Exit. But when I reopen Sql Editor again the next day, it says that the "Application has been abnormally terminated", and I have to uncheck several "SqlQuery1.sql" instances
|
|
Mon Mar 11, 2024 10:13 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
This might be related to Windows UAC. Does it remember them unchecked if you start it in Run as Administrator mode?
|
|
Mon Mar 11, 2024 2:30 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
|
|
If I start Sql Assistant as Administrator and select SqlEditor 64 bit from the SqlAssistant menu, then set up all the files and File Exit, it still doesn't retain the list that was saved last. It still has the list from a while back, perhaps the last Sql Assistant version before updating.
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
This might be related to Windows UAC. Does it remember them unchecked if you start it in Run as Administrator mode? |
|
|
Mon Mar 11, 2024 8:31 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
Here is some background information that may help with troubleshooting this issue. In version 12.4 the recent file list and file states get saved in %APP_DATA%\Roaming\SQL Assistant\12.4\saDocMng.db which is a small SQLite database. In previous versions it was saved in saDocMng.xml XML file. Version of 12.4 checks if that XML file is present, and if yes, it imports contents of that file into and deletes it.
Can you please check if you still have saDocMng.xml file, and if saDocMng.db is writable. I assume that you are running the latest version 12.4.
|
|
Mon Mar 11, 2024 9:37 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
|
|
Hi,
Yes the sqlite table is writable. There's both the xml and the db in that folder (btw, %APPDATA%, rather than %APP_DATA%).
The saDocMng.xml is from 07/27/2023. The db is from today, of course. Should I delete the .xml, since this version isn't using it?
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Here is some background information that may help with troubleshooting this issue. In version 12.4 the recent file list and file states get saved in %APP_DATA%\Roaming\SQL Assistant\12.4\saDocMng.db which is a small SQLite database. In previous versions it was saved in saDocMng.xml XML file. Version of 12.4 checks if that XML file is present, and if yes, it imports contents of that file into and deletes it.
Can you please check if you still have saDocMng.xml file, and if saDocMng.db is writable. I assume that you are running the latest version 12.4. |
|
|
Tue Mar 12, 2024 7:10 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
Yes, please delete or better move the xml file somewhere else temporarily. And restart SQL Assistant after that. I wonder why it's unable to delete it.
|
|
Wed Mar 13, 2024 7:30 am |
|
![](templates/GreenTech/images/spacer.gif) |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
|
|
No luck. I'll just remove the entries from the sqlite table later.
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Yes, please delete or better move the xml file somewhere else temporarily. And restart SQL Assistant after that. I wonder why it's unable to delete it. |
[img]
[/img]
|
|
Wed Mar 13, 2024 9:09 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
It would be great to understand what's going on in order to fix the root cause and make sure the issue doesn't come back.
|
|
Wed Mar 13, 2024 11:19 am |
|
![](templates/GreenTech/images/spacer.gif) |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
|
|
Sounds good, let me know what I should look at next. I haven't removed anything yet.
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
It would be great to understand what's going on in order to fix the root cause and make sure the issue doesn't come back. |
|
|
Thu Mar 14, 2024 9:55 am |
|
![](templates/GreenTech/images/spacer.gif) |
|