Product Home
DTM SQL editor Online Documentation
General
Product profile
Product versions
Database tools
Install software
Upgrade software
Uninstall software
System requirements
How to buy
Product features
User interface
Hot keys
SQL editor
Search and replace
Data export
SQL library
Results viewer
Connect to database
Macros: definition and using
Database schema viewer
Find database object
Data editor
Schema object
Filter database schema
Version control
Command line options
Settings and options
SQL builder
SQL builder
Select type of the statement
Specity objects for select
Build WHERE cause
Select tables or views
Select one table or view
Select fields
Set or change values
ORDER BY and GROUP BY
Create table
Create index
Create view
Plug-ins and SDK
Plug-ins and SDK
Data structures
Plug-in sample, sources
Plug-ins Library
General information
Directory by DBMS
MS SQL Server
Run Query Analyzer
Oracle
Run SQL*Plus
General
Insert Module Header
External preprocessor
Run external tool
Run after script execution
Save/Load Hisroty
Send script by e-mail
Simply preprocessor
WinDiff interface
Directory by functions
Editor plug-ins
Insert Module Header
Run external tool
Run Oracle SQL*Plus
Run MS Query Analyzer
Send script by e-mail
Schema plug-ins
Results plug-ins
Common plug-ins
Run WinDiff
Save/Load Hisroty
Preporcessors
External preprocessor
Simply preprocessor
After execution plug-ins
Run after script execution
Information
Licence agreemnet
Technical support
Send feedback
FAQ and tips
Program tutorial
Troubleshooting guide
Glossary
SQL reference
SQL quick reference

Results viewer

If the SQL script being executed produces the resulting recordset(s) You can view it in the "Results" pane of the main window.

It allows You:

  • to list the recordset one record by one or page by page (Up, Down, Page Up and Page Down buttons);
  • to seek begin or end of the recordset using Ctrl+PageUp and Ctrl+PageDown buttons.
  • to set the width of columns representing the fields of records;
  • to see the current record number and total number of records in the status bar of the dialog;
  • to place the cursor directly to the the chosen record;

Placing the mouse cursor over the column header will tell You the type of data stored in this field:

There is a picture of local menu accessed by the right click inside the results window.

Using this menu you can:

  • copy selected items onto clipboard
  • call "export dialog"
  • run "results" plug-ins, if present

Using toolbar buttons you can:

  • refresh data in the grid

  • select all present data in grid

  • copy selected data

  • call "export dialog" for selected type of the export

  • sort results by the selected column (field)

  • print results

"Results" window contains few result sets when you execute more then one SQL statement or statement (same as procedure call) returns multiply result sets. You can switch between result sets by click on the corresponding tab: