RE: Lost Personal and Named SQL

In View|Options|Editor|Code Assist do you have this option checked? "Show only statements for the active session" If so, uncheck it and see if your statements are there. When checked all SQL that was executed in a session other than the active session will be hidden. If that option has no effect you can send me your savedsql.dat file from 10.6 to me offline and I'll look into why it's not carrying over.

Michael

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of John Graves
Sent: Thursday, March 29, 2012 3:51 PM
To: [email protected]
Subject: [toad] Lost Personal and Named SQL

Running 11.0.0.116. A few weeks ago I lost all my Personal and Named
SQL. I didn't have time to deal with it then, but now I have the time.

I went back to my 10.6 installation, fired it up and verified that my
saved SQL is still in that version. I went back to 11 and tried to
import from my 10.6 installation. I tried Append with the appropriate
check boxes checked and also Replace. Neither gave me back my saved
SQL.

I then renamed my existing 11 SavedSQL.dat and simply copied the one
over from the 10.6 install to the 11 install. Still no Saved or Named
SQL.

What am I missing or doing incorrectly? Any ideas?

John


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

Yahoo! Groups Links





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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/