602SQL Documentation Index  

Text Editor

The text editor provides the following:

Text Editor Properties

The editor in 602SQL is implemented as a window with many tabs. The definition of one object can be displayed on each tab.

Each tab remembers editing modifications. It is possible to return to the state before modification be executing the Undo command. You may redo the changes by calling the Redo command.

Each user may choose a font and font size. Different objects are distinguished in the text with different colors (comments, SQL statements, etc.).

You can switch between insert and overwrite mode in the editor (distinguished by the cursor shape). New lines are automatically shifted to the position on the beginning of the previous line when writing text. You can insert bookmarks into the text and cycle between them. Selected blocks of lines can be indented as a whole. You can search for a string in the text, or replace one string with another. Keyboard and mouse operation are similar to other Windows editors.

The information line tells you about the cursor position in the text.

Controlling the Editor

Keyboard commands

Arrows: Move the cursor in all directions.

Ctrl+"right arrow": Jump to the beginning of the next word.

Ctrl+"left arrow": Jump to the previous of the next word.

Home: Jump to the beginning of the line.

End: Jump to the end of the line.

Page Up: Jump one page up.

Page Down: Jump one page down.

Insert: Switch between insert and overwrite.

Delete: Delete a character. Causes the next line to be appended to the current line. If the cursor is on the end of the current line.

Ctrl+Delete: Delete up to the end of word.

Backspace: Delete the character to the left. If the character does not exist, the line will be appended to the previous line.

Ctrl+Z: Undo the last change.

Ctrl+Y: Redo the last undo.

Ctrl+A: Select the entire text as a block.

Ctrl+X: Cut the block to the clipboard.

Ctrl+C : Copy the block to the clipboard.

Ctrl+V: Paste the clipboard to the cursor position.

TAB: Move the cursor to the position that can be divided by four. Indent the select block by one character.

Shift+TAB: Indent the selected block by one character to the left.

Ctrl+F: Search the text for a string.

Ctrl+H: Replace a string in the text.

F3: Repeat the last search or text replacement.

Ctrl+S: Save the text to the database.

Ctrl+Shift+S: Save the text to the database under a different name.

Ctrl+F12: Insert/remove a bookmark on the current line.

F12: Move to the next bookmark.

Shift+F12: Move to the previous bookmark.

Ctrl+Shift+F12: Delete all bookmarks.

You can select a text block by moving to the start position, then hold the Shift key and move the cursor to the end of the block.

Mouse actions

Click moves the cursor to the specified place.

Double-click selects a word as a block.

Drag when holding the left button selects a text block continuously.

Click the selected block and a drag while holding the left button moves the block to the place where you release the button.

Same actions as above + Ctrl key will copy the block instead.

Right click evokes the pop-up menu with a list of actions for a word or block under the cursor.