RE: Power outage, lost connection info and saved sql

All history, personal, and named statements are saved in that same file. There are options in Options|Editor|Code Assist for SQL Recall. Make sure that you have the option to show only those for the active session unchecked to be sure that everything is visible. Also make sure that you have no filtering in the SQL Recall window to filter by DB for example.

Michael

From: [email protected] [mailto:[email protected]] On Behalf Of Wendy Penfold
Sent: Tuesday, April 24, 2012 9:34 AM
To: [email protected]
Subject: Re: [toad] Power outage, lost connection info and saved sql



Hi Michael, I'm still at Toad 11.0.0.116.  Saving the previous copy sounds like a good idea.  i had a backup of my user files from January and I tried moving that to my user files directory, but my Named SQL doesn't seem to be in there.  Does it get saved somewhere else?

On 4/23/2012 5:36 PM, Michael Staszewski wrote:


Hi Wendy. I've received your .err file offline and unfortunately am able to get nothing from it. If I open the file in Notepad++ I can clearly see many statements in there, but the file is binary and I'm not sure how to terminate the file properly by stripping the trailing nulls (the corruption) in such a way that Toad can still load the file without error. We use Delphi's built-in component streaming functionality for this so it's not a file format that I fully understand.

This comes up at times under circumstances I cannot explain. I do not know why a power outage would cause corruption in this file. It would seem unlikely that the saving of the file would occur at the precise moment the power went out, but you are not the first to report problems with this file under unexpected circumstances. In an attempt to alleviate this annoyance I've made a change. When SavedSQL.dat is saved, the previous copy of it is saved to SavedSQL.bak. When loading the file from disk if corruption is detected in the .dat file an attempt to load the .bak file is made. This isn't the perfect solution, but perhaps it will eliminate the total loss of all saved SQL.

Did you just upgrade to 11.5 by chance? If so you may still have your 11.0 appdata folder on disk. Look at your appdata folder and look for the 11.0_uninstalled folder. If you close Toad you can copy the SavedSQL.dat file from the "11.0_uninstalled\User Files" folder into your 11.5 user files folder. You'll lose any statements saved during your 11.5 use, but perhaps that hasn't been for too many days now since 11.5 was just released.

Michael

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of Wendy Penfold
Sent: Monday, April 23, 2012 12:59 PM
To: ToadList
Subject: [toad] Power outage, lost connection info and saved sql

Hi, We had a power outage when I was using Toad, when my machin came
back up and I tried to start Toad up again, I got an error that
Connection info can't be shared between computer and that the file will
be deleted...? So, all my connections and passwords were deleted...ok,
but what I'm really missing is my saved sql. I got an error saying it
couldn't be opened and it saved it to a .err file. Is there any way I
can get my saved sql back?

------------------------------------

Yahoo! Groups Links