Toad World® Forums

History-F8


#1

Message from: falujar

Regards
I’m a new toad for oracle user. I read in help section that I can use F8 or
ALT+up to scroll through history sql commands. When I press that key, history
space is empty. Does anyone know how to activate “history option”
Thank you so much for your help


Historical Messages

Author: falujar
Date: Thu Apr 07 14:36:22 PDT 2011
Regards
I’m a new toad for oracle user. I read in help section that I can use F8 or
ALT+up to scroll through history sql commands. When I press that key, history
space is empty. Does anyone know how to activate “history option”
Thank you so much for your help
__



#2

Afternoon falujar,

I’m a new toad for oracle user. I read in help section that
I can use F8 or ALT+up to scroll through history sql
commands. When I press that key, history space is empty.
Does anyone know how to activate “history option”
Thank you so much for your help

When you press F8, there are three tabs on the window that appears,
History, Personal, Named. Can you see anything on any of the tabs?

The history is kept in a file named:
C:\Documents and Settings\Application Data\Quest
Software\Toad for Oracle\User Files\SavedSQL.dat and that file
should not be read only. In addition, your user should be able to write
to it. (Don’t try editing it in Notepad - it’s a binary file as well as
some text!).

If you are running Vista or above, and an older version of Toad (9.x or
lower) then you may be hitting a problem whereby Vista (and above)
flatly refuses to allow you to put files in folders below “Program
Files”.

HTH

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#3

Morning Norm
I see History, personal and named tabs but they are empty. I’m using windows 7 and toad for oracle 10.6.0.42. I couldn’t find savedsql.dat file.
My workmate is using the same O.S and toad version and she can see sql history at the left. What else can I check?
Thank you so much


#4

Hi falujar,

I’ve posted this query, and the whole thread to the Toad list rather
than the toadsql list. More developers hang out there than here I
suspect. If you can’t see the savedsql file, I’m at a loss to advise I’m
afraid.

Can you take a copy of your colleague’s file and paste it into the
appropriate location on your Windows 7 PC. When you restart Toad, you
should then see your colleague’s history and saved sql (I hope!).

Cheers,
Norm. [TeamT]

Morning Norm
I see History, personal and named tabs but they are empty.
I’m using windows 7 and toad for oracle 10.6.0.42. I
couldn’t find savedsql.dat file.
My workmate is using the same O.S and toad version and she
can see sql history at the left. What else can I check?
Thank you so much


Historical Messages

Author: falujar
Date: Fri Apr 08 06:49:37 PDT 2011
Morning Norm
I see History, personal and named tabs but they are empty.
I’m using windows 7 and toad for oracle 10.6.0.42. I
couldn’t find savedsql.dat file.
My workmate is using the same O.S and toad version and she
can see sql history at the left. What else can I check?
Thank you so much
__

Author: Norman Dunbar
Date: Fri Apr 08 05:59:02 PDT 2011
Afternoon falujar, >> I’m a new toad for oracle user. I read
in help section that >> I can use F8 or ALT+up to scroll
through history sql >> commands. When I press that key,
history space is empty. >> Does anyone know how to activate
“history option” >> Thank you so much for your help When you
press F8, there are three tabs on the window that appears,
History, Personal, Named. Can you see anything on any of the
tabs? The history is kept in a file named: C:\Documents and
Settings\Application Data\Quest Software\Toad for
Oracle\User Files\SavedSQL.dat and that file should not be
read only. In addition, your user should be able to write to
it. (Don’t try editing it in Notepad - it’s a binary file as
well as some text!). If you are running Vista or above, and
an older version of Toad (9.x or lower) then you may be
hitting a problem whereby Vista (and above) flatly refuses
to allow you to put files in folders below “Program Files”.
HTH Cheers, Norm. [TeamT] Information in this message may be
confidential and may be legally privileged. If you have
received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else. We
have checked this email and its attachments for viruses. But
you should still check any attachment before opening it. We
may have to make this message and any reply to it public if
asked to under the Freedom of Information Act, Data
Protection Act or for litigation. Email messages and
attachments sent to or from any Environment Agency address
may also be accessed by someone other than the sender or
recipient, for business purposes. If we have sent you
information and you wish to use it please read our terms and
conditions which you can get by calling us on 08708 506 506.
Find out more about the Environment Agency at
www.environment-agency.gov.uk
__

Author: falujar
Date: Thu Apr 07 14:36:22 PDT 2011
Message from: falujar Regards I’m a new toad for oracle
user. I read in help section that I can use F8 or ALT+up to
scroll through history sql commands. When I press that key,
history space is empty. Does anyone know how to activate
“history option” Thank you so much for your help
_______________________________________ Historical Messages
Author: falujar Date: Thu Apr 07 14:36:22 PDT 2011 Regards
I’m a new toad for oracle user. I read in help section that
I can use F8 or ALT+up to scroll through history sql
commands. When I press that key, history space is empty.
Does anyone know how to activate “history option” Thank you
so much for your help __ _______________________________________
__



#5

Hi Norm
I’ve attached an image. Maybe with that you can have any idea about what happen with my toad for oracle configuration.
Thank you so much


#6

What button do you press when you execute statements in Toad?

if it’s also F5, then you’ll never build a history list.

Try executing with F9 and looking at that list again


#7

Message from: falujar

thank you.


Historical Messages

Author: falujar
Date: Fri Apr 08 14:54:49 PDT 2011
thank you.
__

Author: Jeff Smith
Date: Fri Apr 08 12:01:37 PDT 2011
What button do you press when you execute statements in Toad? if it’s also
F5, then you’ll never build a history list. Try executing with F9 and
looking at that list again
__

Author: falujar
Date: Fri Apr 08 12:00:24 PDT 2011
Hi Norm
I’ve attached an image. Maybe with that you can have any idea about what
happen with my toad for oracle configuration.
Thank you so much
__

Author: Norman Dunbar
Date: Fri Apr 08 08:43:10 PDT 2011
Hi falujar, I’ve posted this query, and the whole thread to the Toad list rather
than the toadsql list. More developers hang out there than here I suspect. If
you can’t see the savedsql file, I’m at a loss to advise I’m afraid. Can you
take a copy of your colleague’s file and paste it into the appropriate location
on your Windows 7 PC. When you restart Toad, you should then see your
colleague’s history and saved sql (I hope!). Cheers, Norm. [TeamT] >> Morning
Norm >> I see History, personal and named tabs but they are empty. >> I’m using
windows 7 and toad for oracle 10.6.0.42. I >> couldn’t find savedsql.dat file.

My workmate is using the same O.S and toad version and she >> can see sql
history at the left. What else can I check? >> Thank you so much >> >>
_______________________________________ >> >> Historical Messages >> >> >>
Author: falujar >> Date: Fri Apr 08 06:49:37 PDT 2011 >> Morning Norm >> I see
History, personal and named tabs but they are empty. >> I’m using windows 7 and
toad for oracle 10.6.0.42. I >> couldn’t find savedsql.dat file. >> My workmate
is using the same O.S and toad version and she >> can see sql history at the
left. What else can I check? >> Thank you so much >> __ >> >> Author: Norman
Dunbar >> Date: Fri Apr 08 05:59:02 PDT 2011 >> Afternoon falujar, >> I’m a new
toad for oracle user. I read >> in help section that >> I can use F8 or ALT+up
to scroll >> through history sql >> commands. When I press that key, >> history
space is empty. >> Does anyone know how to activate >> “history option” >> Thank
you so much for your help When you >> press F8, there are three tabs on the
window that appears, >> History, Personal, Named. Can you see anything on any of
the >> tabs? The history is kept in a file named: C:\Documents and >>
Settings\Application Data\Quest Software\Toad for >> Oracle\User
Files\SavedSQL.dat and that file should not be >> read only. In addition, your
user should be able to write to >> it. (Don’t try editing it in Notepad - it’s a
binary file as >> well as some text!). If you are running Vista or above, and >>
an older version of Toad (9.x or lower) then you may be >> hitting a problem
whereby Vista (and above) flatly refuses >> to allow you to put files in folders
below “Program Files”. >> HTH Cheers, Norm. [TeamT] Information in this message
may be >> confidential and may be legally privileged. If you have >> received
this message by mistake, please notify the sender >> immediately, delete it and
do not copy it to anyone else. We >> have checked this email and its attachments
for viruses. But >> you should still check any attachment before opening it. We

may have to make this message and any reply to it public if >> asked to under
the Freedom of Information Act, Data >> Protection Act or for litigation. Email
messages and >> attachments sent to or from any Environment Agency address >>
may also be accessed by someone other than the sender or >> recipient, for
business purposes. If we have sent you >> information and you wish to use it
please read our terms and >> conditions which you can get by calling us on 08708
506 506. >> Find out more about the Environment Agency at >>
www.environment-agency.gov.uk >> __ >> >> Author: falujar >> Date: Thu Apr 07
14:36:22 PDT 2011 >> Message from: falujar Regards I’m a new toad for oracle >>
user. I read in help section that I can use F8 or ALT+up to >> scroll through
history sql commands. When I press that key, >> history space is empty. Does
anyone know how to activate >> “history option” Thank you so much for your help

_______________________________________ Historical Messages >> Author:
falujar Date: Thu Apr 07 14:36:22 PDT 2011 Regards >> I’m a new toad for oracle
user. I read in help section that >> I can use F8 or ALT+up to scroll through
history sql >> commands. When I press that key, history space is empty. >> Does
anyone know how to activate “history option” Thank you >> so much for your help
__ _______________________________________ >> __ >>


__

Author: falujar
Date: Fri Apr 08 06:49:37 PDT 2011
Morning Norm
I see History, personal and named tabs but they are empty. I’m using windows
7 and toad for oracle 10.6.0.42. I couldn’t find savedsql.dat file.
My workmate is using the same O.S and toad version and she can see sql history
at the left. What else can I check?
Thank you so much
__

Author: Norman Dunbar
Date: Fri Apr 08 05:59:02 PDT 2011
Afternoon falujar, >> I’m a new toad for oracle user. I read in help section
that >> I can use F8 or ALT+up to scroll through history sql >> commands. When I
press that key, history space is empty. >> Does anyone know how to activate
“history option” >> Thank you so much for your help When you press F8, there are
three tabs on the window that appears, History, Personal, Named. Can you see
anything on any of the tabs? The history is kept in a file named: C:\Documents
and Settings\ \Application Data\Quest Software\Toad for Oracle\ \User
Files\SavedSQL.dat and that file should not be read only. In addition, your user
should be able to write to it. (Don’t try editing it in Notepad - it’s a binary
file as well as some text!). If you are running Vista or above, and an older
version of Toad (9.x or lower) then you may be hitting a problem whereby Vista
(and above) flatly refuses to allow you to put files in folders below “Program
Files”. HTH Cheers, Norm. [TeamT] Information in this message may be
confidential and may be legally privileged. If you have received this message by
mistake, please notify the sender immediately, delete it and do not copy it to
anyone else. We have checked this email and its attachments for viruses. But you
should still check any attachment before opening it. We may have to make this
message and any reply to it public if asked to under the Freedom of Information
Act, Data Protection Act or for litigation. Email messages and attachments sent
to or from any Environment Agency address may also be accessed by someone other
than the sender or recipient, for business purposes. If we have sent you
information and you wish to use it please read our terms and conditions which
you can get by calling us on 08708 506 506. Find out more about the Environment
Agency at www.environment-agency.gov.uk
__

Author: falujar
Date: Thu Apr 07 14:36:22 PDT 2011
Message from: falujar Regards I’m a new toad for oracle user. I read in help
section that I can use F8 or ALT+up to scroll through history sql commands. When
I press that key, history space is empty. Does anyone know how to activate
“history option” Thank you so much for your help
_______________________________________ Historical Messages Author: falujar
Date: Thu Apr 07 14:36:22 PDT 2011 Regards I’m a new toad for oracle user. I
read in help section that I can use F8 or ALT+up to scroll through history sql
commands. When I press that key, history space is empty. Does anyone know how to
activate “history option” Thank you so much for your help __


__



#8

thank you.