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

Editor commands

You can load SQL scripts using one of the following methods:

  • type the name of file as the command line argument
  • direct file loading
  • automatic file loading
  • drag-n-drop the file into the main window of the editor
  • restore script from backup copy (after software or hardware failure).

You can perform clipboard operations either with mouse or keyboard, or by selecting the items from the local menu that can be accessed by the right mouse button click inside the main window.

Moreover, you can search and replace any items. Undo/Redo functions are also implemented. You can press Ctrl-Z and Ctrl-Y without any worry to lose your work.

There is a picture of local menu accessed by the right click inside the editor window. See the picture below:

Using this menu you can:

  • perform clipboard operations.
  • do bulk text operations.
  • search/replace.
  • execute other additional operations.

Using toolbar buttons You can:

  • load and save files.
  • start new file in new editor window.
  • call search and replace dialog.
  • perform clipboard operations.
  • access to Redo/Undo features.
  • print script text.
  • call "macros" dialog.
  • comment and uncomment script line or selected fragment by the one click.

Using Ctrl+G hot key you can go to specified line of the current script. Besides product allows you to use bookmark: press Ctrl+<number key> to set bookmark for current cursor position and use Ctrl+Shift+<number key> for go to stored bookmark. You can define up to 10 ('0'-'9') bookamrks. Bookmarks are script-specific and SQL editor does not save them between sessions.

To comment the current line out or to uncomment it, just press the button with two "minus sign" on it. To comment out a block, select it and press the button with a slash and an asterisk on it. If you press this button when the cursor is in the commented area, it will be uncommented.

Adding plug-ins to the DTM SQL editor helps users to extend the functionality of the editor tool  (PT_TEXT plug-in type). It is also a possibility for the third party developers wishing to make additions to the program.

See also: "macros: definition and use", "search and replace"