# Toad - SQl Editor

**URL:** <https://forums.toadworld.com/t/toad-sql-editor/10142>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 12, 2011, 7:01am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142 "2011-01-12T07:01:12Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [January 12, 2011, 7:01am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/1 "2011-01-12T07:01:12Z")

</div>

I have a problem with the display of my editor. I realized I clicked something on my screen and I could not see the screen where we write the queries anymore. I am using Toad version 9.6.0.

I tried various other settings but could not get the display screen back where we write the queries. Can someone help!  
Please suggest asap.

Thanks

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 7:33am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/2 "2011-01-12T07:33:18Z")

</div>

> > I have a problem with the display of my editor. I realized I  
> > clicked something on my screen and I could not see the  
> > screen where we write the queries anymore. I am using Toad  
> > version 9.6.0.

It sounds like you have managed to maximise the grid display area. Click  
on that and press F2 - you should now see the editing area maximised. If  
so, try resizing the grid area downwards (F2 again to display the grid  
area) to allow you to see both at once.

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](http://www.environment-agency.gov.uk)

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 12, 2011, 7:33am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/3 "2011-01-12T07:33:39Z")

</div>

Try F2 or Shift+F2

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 12, 2011, 7:40am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/4 "2011-01-12T07:40:53Z")

</div>

I’ve noticed if you resize a window - editor, session browser – you  
can pretty easily make it such that the top or bottom panel  
‘disappear’ and you are unable to drag it back in the same space.  
You have to resize the window/app again to expose the splitter, which is usually  
stuck at the bottom. It would be nice if the splitter were forced to ALWAYS be  
visible on a form…

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 7:42am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/5 "2011-01-12T07:42:58Z")

</div>

Agreed – place on idea pond and I will vote for it J

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 7:43am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/6 "2011-01-12T07:43:34Z")

</div>

Hi Jeff,

> > It would be nice if the splitter were forced to  
> > ALWAYS be visible on a form...  
> > Or, maybe, a right click "rest this window to default" option in the  
> > context menu?

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](http://www.environment-agency.gov.uk)

---

<div class="post-metadata">

**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:** [January 12, 2011, 7:44am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/7 "2011-01-12T07:44:10Z")

</div>

I suspect that Jeff’s original solution will work for you, but if it does not  
and if you can see the toolbar then reset the current desktop. See attached  
screenshot.

Michael  
 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/3/3bfc150282699f9a8b719ef2ea6ed54a49221c7f.png)

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 12, 2011, 7:47am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/8 "2011-01-12T07:47:29Z")

</div>

Yes – many windows need rest these days J

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 7:48am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/9 "2011-01-12T07:48:29Z")

</div>

Hi Michael,

> I suspect that Jeff's original solution will work for you, but if it  
> does not and if you can see the toolbar then reset the current desktop.  
> See attached screenshot.  
> Interesting.

I'm on 10.5.1.3 and had my grid extended to the very top covering up the  
MOE.

I tried your suggestion and while "other things" re-appeared on screen,  
the MOE didn't. I still had the grid covering it up.

Maybe it's because my splitter was still accessible, but then again ...

--

Cheers,  
Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [January 12, 2011, 7:49am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/10 "2011-01-12T07:49:32Z")

</div>

Hi Bert,

> Yes – many windows need rest these days J  
> Thanks! Looks like I need one myself!

--  
Cheers,  
Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [January 13, 2011, 8:35am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/11 "2011-01-13T08:35:10Z")

</div>

Does not help. My version is 9.6.1, am still not able to see the screen where I write queries. Am not able to see the screen.

Please help!

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 13, 2011, 8:41am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/12 "2011-01-13T08:41:47Z")

</div>

Try un-maximizing the window and resizing it in both directions, see if you can  
get the splitter to appear

Window \> Tile Vertical may do the trick too

---

<div class="post-metadata">

**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:** [January 13, 2011, 8:45am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/13 "2011-01-13T08:45:25Z")

</div>

Did you try my earlier suggestion of resetting the desktops? Norman reported that it didn’t help completely, but I think that you could then get to the splitter. You could always try the tactical nuke approach. Close Toad and delete your User Files\Editor\*.lay if those files exist. I see them in 9.7, but can’t recall if 9.6 used that desktop naming convention or not. If you do not see them then look for User Files\*Desktops.xml and remove any found.

Michael

---

<div class="post-metadata">

**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:** [January 13, 2011, 8:46am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/14 "2011-01-13T08:46:39Z")

</div>

I should clarify that if you have the .lay files only delete the Editor\*.lay, do not remove the OriginalEditor\*.lay files.

Michael

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [January 13, 2011, 9:00am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/15 "2011-01-13T09:00:55Z")

</div>

I believe it is the same thing for me. I am trying to uninstall and re-install TOAD

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 13, 2011, 9:17am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/16 "2011-01-13T09:17:46Z")

</div>

Whoa, that’s a pretty harsh solution. I can always play around with the  
window enough to get the panel to come back…

---

<div class="post-metadata">

**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:** [January 13, 2011, 9:28am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/17 "2011-01-13T09:28:03Z")

</div>

It’s not that harsh. It just resets the desktop layout which takes about 2  
seconds to recreate.

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [January 13, 2011, 9:30am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/18 "2011-01-13T09:30:20Z")

</div>

Not blowing away the desktop INI/XML files – blowing away Toad and  
re-installing…that seems harsh to me at least. ESP if you have to ask a  
desktop ADMIN to do that for you.

---

<div class="post-metadata">

**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:** [January 13, 2011, 9:36am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/19 "2011-01-13T09:36:15Z")

</div>

Ah, sorry, Misread.

---

<div class="post-metadata">

**Author:** ![samantha.logic](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@samantha.logic](https://forums.toadworld.com/u/samantha.logic)\
**Post date:** [October 3, 2013, 2:43am UTC](https://forums.toadworld.com/t/toad-sql-editor/10142/20 "2013-10-03T02:43:37Z")

</div>

I’ve noticed if you resize a window - editor, session browser – you

can pretty easily make it such that the top or bottom panel

‘disappear’ and you are unable to drag it back in the same space.

You have to resize the window/app again to expose the splitter, which is usually

stuck at the bottom. It would be nice if the splitter were forced to ALWAYS be

visible on a form. Like here with [SQL database designing](http://docs.espressologic.com/docs/logic-designer/database) shows

[Next page](https://forums.toadworld.com/t/toad-sql-editor/10142.md?page=2)
