About TDV SQL Editor

The TDV SQL/Text editor lets you execute SQL statements that are not bound to a resource. You can define and execute any SQL statement that can be executed for a composite view.

The following image shows a snapshot of the SQL Editor with a query. The line numbers in the SQL editor aids users in coding.

 

Below are some of the features of the TDV SQL Editor:

• Line numbers can be turned on and off from the user preference. Line number color can be customized as well. You can set options such as Auto-complete, Line number, Line wrap, AutoCapitilization, Syntax Coloring, Fonts etc. from the Editor Preferences window. Access the Editor Preferences by choosing Edit->Options from the TDV Studio menu and choosing the Editor tab.

• The Occurrence bar on the right edge of the editor shows the current matches in the Find/Replace context

• You can add Bookmarks. These bookmarks are not retained when the content is reloaded. They are useful in the current editing session only.

• The Context menu is added for the most commonly used editor commands You can activate the context menu by Right mouse click).

• Line numbers can be turned on and off from the user preference. Line number color can be customized as well.

• Status bar now includes the read-only indicator, line-wrap toggle, and the line and character count tool-tip over the cursor location indicator.

Refer to section Studio Code Editing Keyboard Shortcuts for a list of Keyboard shortcuts