SQL ran in editor is not being saved in SQL Recall's history tab as expected.
RESOLUTION 1:
Verify settings in View | Toad Options | Editor | Code Assist -- SQL Recall.
RESOLUTION 2:
Run query in editor with F9. If it is not run with F9 Execute Statement, it will not be saved as history.
RESOLUTION 3:
Rename the SavedSQL.dat file in C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\<version>\User Files.
Keep in mind that doing so will force a new blank SavedSQL file to be created, and there will be no access to previous history, and Named/Personal SQL.
It is not advisable to manually edit the SavedSQL.dat files.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy