TOAD sometimes crashes. When it does it allows us to recover files that were open when it crashed. When I recover these files it opens them all in a single SE window. I then have to go through copy and pasting them into separate SE windows for each connection that was open (and trying to remember which applied to which). Could TOAD remember the connection that had the script open and “recover” it in that connection, or at least group them accordingly?
Or if we could drag tabs between connections/SE windows, that would be really good with an option asking if we’d like to move or copy it?
Richard
Morning Richard,
I then have to go through copy and pasting them into
separate SE windows for each connection that was open (and
trying to remember which applied to which).
This might help.
When you recover all the broken MOE files that were open when Toad
crashed, they are not attached to any connections. Once you open a
connection to an appropriate database again, you do not have to cut and
paste. What you should do is click on the "change connection" button
when you have focus in the editor that holds the recovered file.
The button looks like a wire with a (US style?) electric plug on the end
and a drop down arrow. (on my 10g Toad it's the first button on the
STANDARD toolbar.)
Click the drop down, select the connection and the editor window is now
associated with that connection.
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
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
Hi Richard,
Yes, this is definitely a good ER. The idea has come up in the past, and I said
then that I could include the database name in the backup file metadata and so
try to open the file in a MOE with that connection. I obviously haven’t
gotten to it yet, but I will for the fall release.
