Following is a list of additions to Interactive SQL introduced in version 12.0.1.
By default, the text completion window now opens automatically when you type in the SQL Statements pane. You can also open the text completion window by clicking Edit » Open Text Completer or pressing Ctrl+Space.
By default, SQL keywords and completed database object names are enclosed in double quotes.
SQL statements and keywords are now included in the list of suggestions.
The text completion window now handles databases where strings are treated as case-sensitive, but identifiers are not.
The following keyboard shortcuts have changed:
|Old shortcut||New shortcut||Description|
|Tab||Ctrl+A||Shows a context-free list of matches.|
|+||Ctrl+Plus Sign (+)||Adds the item with its parameter list to the SQL Statements pane.|
|*||Ctrl+Asterisk||Adds the item with its parameter and type list to the SQL Statements pane.|
|'||Ctrl+Double quote (")||Adds the item enclosed in quotation marks to the SQL Statements pane.|
|N/A||Tab||Accepts the selection and closes the text completion window.|
For a complete list of shortcuts, see Text completion keyboard shortcuts.
For more information, see Using text completion.
New Import/Export option When you click Options » Import/Export, you can specify how nulls should be exported in the Export NULL values as field. See output_nulls option [Interactive SQL].
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|