Toad World® Forums

"Merging" SQL Recall history ?


#1

In TOAD For Oracle (currently using version 12), I see that there is an option in SQL Recall (F8) to import and export savedsql.dat files now. I also see that there is an “append” option, but it doesn’t seem to work for me.

What I want to be able to do is take a savedsql.dat file from another computer and MERGE it into my savedsql.dat. I have tried to do this with the Import and Append option, but it always overwrites my current history with just the history from the file I am importing. Is this a bug or is it not designed to work that way.

How can I merge two savedsql.dat files together and have access to all the combined history going forward, that’s my goal.

~bill


#2

There is no way to merge.

Michael

On 01/14/2014 02:40 PM, billprew wrote:

"Merging" SQL Recall history ?

Thread created by billprew
In TOAD For Oracle (currently using version 12), I see that there is an option in SQL Recall (F8) to import and export savedsql.dat files now. I also see that there is an “append” option, but it doesn’t seem to work for me.

What I want to be able to do is take a savedsql.dat file from another computer and MERGE it into my savedsql.dat. I have tried to do this with the Import and Append option, but it always overwrites my current history with just the history from the file I am
importing. Is this a bug or is it not designed to work that way.

How can I merge two savedsql.dat files together and have access to all the combined history going forward, that’s my goal.

~bill

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Okay, I guess it is what it is then. So what is the “append” setting on the Import dialog all about, what is that trying to say?

~bill


#4

Ok, I should’ve checked that first. I see what you’re talking about. I forgot that feature was even added. It’s working for me, perhaps you’re at the max history limit and that’s blocking. In Options|Editor|Code Assist increase the SQL Recall statements to
save setting. Double it or so. Click OK and now try your import again.

On 01/14/2014 02:46 PM, billprew wrote:

RE: “Merging” SQL Recall history ?

Reply by billprew
Okay, I guess it is what it is then. So what is the “append” setting on the Import dialog all about, what is that trying to say?

~bill

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#5

Bingo! Thanks. I did wonder at one point if there might be a size limit, but didn’t think to look in “Code Assist” for a history setting. Thanks much for the help.

~bill