# SQL Recall problem **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [July 19, 2015, 10:06am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786 "2015-07-19T10:06:24Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\ **Post date:** [July 19, 2015, 10:06am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/1 "2015-07-19T10:06:24Z")
I’m using the most current beta (.10) in 12.8. Toad doesn’t save the last executed statement into SaveSQL.xml file. The size of file remains the original one (mine is 438 013 byte) , but the last modification always changes to the sysdate. Also an empty record created in View|SQL Recall: the connection string and the time of execution information are correct, but there is no visible statement for it. My Editor|Code Assist|SQL Recall|Save only valid statements is on. The SELECT statement - which is executed in the Editor - gives a result set, with 2 rows. In 12.7 there was an option how many statement should save to the SQL Recall file. I don’t know this option was deprecated in 12.8beta, but I didn’t find any option like this one. In Toad.ini SAVE\_SQLS=1 and NUM\_SQLS=500 are present. T. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [July 20, 2015, 6:50am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/2 "2015-07-20T06:50:19Z")
I can't reproduce this. Can you send me a SQL statement offline that reproduces or are all statements problematic? If all then send me your user files. Thanks. > In 12.7 there was an option... The option has gone away for now. In the past you could limit total number of statements or total per connection. Now I'm letting them all stay, but if load time of the file exceeds 200 ms a warning message is shown suggesting that you cleanup the history. Performance is going to vary per machine and size of each statement, but for me a 200 ms load time was ~7000 statements and that was the point I could detect slowness in the GUI with bulk operations like select all. It was still usable, but noticeably affected. Toad has supported importing of SQL recall for several releases now and during import you can append to what you already have or replace what is there. The option was not obeyed during the import, but the list was trimmed on next execution. So statements you explicitly said to import could be nuked with no way for you to get them back without bumping up that option value. If it is preferred to have the option back instead I'll make it so. Michael ---
**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\ **Post date:** [July 20, 2015, 7:08am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/3 "2015-07-20T07:08:05Z")
None of a statement appear in SQL Recall panel. I’ll send my User Files, but it’s online. I gave the address of it earlier. T. ---
**Author:** ![markagardner](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markagardner](https://forums.toadworld.com/u/markagardner)\ **Post date:** [July 27, 2015, 12:12am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/4 "2015-07-27T00:12:01Z")
I think I have the same issue which is why I’m replying to this thread rather than starting a new one - Sql Recall does not seem to be saving statements properly. When I look at the Sql Recall window, it’s great that everything is grouped into dates but most of it is empty! Bearing in mind that I use Toad every weekday and execute many statements each time, my Sql recall seems a bit light! Friday 24th July, 1 statement (blank), 23rd July, 2 statements (both blank), 22nd - 2, 21st - 1, 20th - 1 then it jumps to Thursday16th (3) then Friday 10th (4), 9th (7) then 3rd (7) but then prior to that it looks a bit more normal, 2nd (34), 1st (17). It used to be (as recently as 12.7) that I could execute a statement and it would immediately appear in my Sql recall but now if I execute a statement, my Sql recall window shows 1 statement for today but it is blank. No matter how many other statements I execute in that connection, I only see 1 blank entry. If I open a new connection, I get a 2nd blank entry! ---
**Author:** ![NoDabble](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@NoDabble](https://forums.toadworld.com/u/NoDabble)\ **Post date:** [July 27, 2015, 2:58am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/5 "2015-07-27T02:58:59Z")
Likewise. Using 12.8.0.11… press F8 to open SQL Recall panel… expand the Today node… none of my SQL statements are shown, just a header for each connection. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [July 27, 2015, 7:17am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/6 "2015-07-27T07:17:09Z")
I didn’t make the cutoff for the next beta, but this will be fixed in 12.8.0.13. In the meantime you can execute with F9 instead of CTRL+Enter as a workaround. Thanks, Michael ---
**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\ **Post date:** [July 27, 2015, 5:15am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/7 "2015-07-27T05:15:52Z")
Is it possible you have a filter on the SQL History window? On Mon, Jul 27, 2015 at 5:59 AM, NoDabble [bounce-NoDabble@toadworld.com](mailto:bounce-NoDabble@toadworld.com) wrote: > **[RE: SQL Recall problem](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25067/55319#55319)** > Reply by NoDabble > Likewise. Using 12.8.0.11... press F8 to open SQL Recall panel... expand the Today node... none of my SQL statements are shown, just a header for each connection. > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25067?subscribe=false) on this subject. > > Or [Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether. > > Toad for Oracle - Beta Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25067/55319?AbuseContentId=730db898-2404-4199-84b8-3a8277c8221f&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) -- **Phyllis Helton** Data Magician Digital Strategies, Cru | Data Sciences & Analytics Office ☎ 407-515-4452 [phyllis.helton@cru.org](mailto:phyllis.helton@cru.org) ![](https://global.discourse-cdn.com/quest/original/3X/9/4/94bf0c4f5e9dec7932932b0cb0b94169a403b1fd.png) ---
**Author:** ![markagardner](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markagardner](https://forums.toadworld.com/u/markagardner)\ **Post date:** [July 28, 2015, 2:36am UTC](https://forums.toadworld.com/t/sql-recall-problem/33786/8 "2015-07-28T02:36:31Z")
Just downloaded 12.8.0.13 and it does indeed seem to be fixed. Thanks Michael. Mark.