Solved

Data displaying outside of viewable window area for SQL results window in Toad

Posted on 2007-11-21
7
635 Views
Last Modified: 2013-12-19
When I run an SQL in Toad and view the results, many of the rows (including the column headings) appear outside of the viewable area of the window. The vertical scroll bar on the right side of the window seem to disappear out the top of the window too. I can't see the results I need!

On the following screenshot, the box on the vertical scrollbar indicates how far through the results I am. From the current location (indicated by the little box being at the top of the bar), it takes about 14 page-down's to get to the bottom of the results. However, from that position, I can page up 10 times before I get to the top of the results (the little box disappears)!
http://opus.co.nz/na/public/toadProblem.jpg

Has anyone seen this before? Cheers!
0
Comment
Question by:Terry Woods
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 30 total points
ID: 20331282
maximize toad then you should be able to see your "grab" bar, if that still doesn't do it then try to move your tabs to the side instead of the top.  

Also, if you're up-to-date on your support, upgrade to the latest release.
9.5 was just released this week.
0
 
LVL 35

Author Comment

by:Terry Woods
ID: 20331328
Have tried that, and can't find a "grab bar" or anything that would seem to fix it. Note that I'm having to use F2 to switch between the SQL query and the results, but am sure I used to be able to show both within the same window - do you know of a setting that might change that?

Will look at upgrading if I can't find anything else that works. I'm running Toad 8.0.0.47 so it's obviously pretty old.
0
 
LVL 27

Assisted Solution

by:kretzschmar
kretzschmar earned 30 total points
ID: 20333183
hmm,
i use Toad 8.0.0.47 too, because this release is stable compared to the later releases

go to the toad.ini and play with the *top-properties (exit toad save and the ini before)

meikl ;-)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 27

Expert Comment

by:kretzschmar
ID: 20333186
mixed some words :-))

(exit toad save and the ini before)
should be
(exit toad and save the ini before)

meikl ;-)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 20333195
a hint:
search for negative values
0
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 190 total points
ID: 20333657
try pressing shift + f2 to see if that helps you. This is to toggle between the orginal size and full size of data grid.

i am curious to know what happend to sql editor ? i cannot see the sql which you have executed
in the sql editor ? is the sql editor also getting disappeared ?

for sql editor, press f2 and f2 again to toggle between full screen sql editor and original size.

If none of these help and also other suggestions are not helping you, then you might
want to uninstall and reinstall to see if that resolves.

Thanks
0
 
LVL 35

Author Comment

by:Terry Woods
ID: 20361280
Thanks nav_kum_v for the shift-F2 tip - that was what solved the issue. A grab-bar appeared once I'd done that, so I could get my split window back to normal.

Thanks everyone else for their help. Awarded a few points for other comments I found interesting/helpful.
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question