• SQL Editor
  • Autocompletion
    • Change Autocompletion Setting
    • Change Autocompletion Case Sensitive Matching
  • Navigate to Next/Previous Highlighted Error
• AquaScript Editor
  • Autocompletion
    • Change Autocompletion Setting
    • Change Autocompletion Case Sensitive Matching
  • Parameter Hint
  • Variable Highlighting
  • Annotator
  • Navigate to Next/Previous Highlighted Error
• HTML and XML Editors
  • Automatic Tag Closure
  • Auto-Update Tag Attributes
  • Breadcrumb Trail
• Image Viewer
• See Also

SQL Editor

Autocompletion

Autocompletion functionality provides suggestions while you type. The autocompletion list displays table names, views, synonyms, and abbreviations for the current schema or all schemas of the connected database. If the auto-popup setting is turned off, you can manually invoke the autocompletion list by using CTRL/Command+Space keystroke. By default, the autocompletion list is sorted by relevance (). You can change this order to alphabetical/lexicographical ().

Change Autocompletion Setting 

AquaScript Editor

Autocompletion

Autocompletion functionality provides suggestions while you type. The autocompletion list displays the object names of packages, variables, classes, and methods used in the AquaScript. If the auto-popup setting is turned off, you can manually invoke the autocompletion list by using CTRL/Command+Space keystroke. By default, the autocompletion list is sorted by relevance (), meaning, the most recently used entries are shown on top. You can change this sorting order to alphabetical (lexicographical ), as shown in the screenshot. Aqua Data Studio shows entries based on your case sensitivity selection when suggesting matches for code completion. By default, the AquaScript Editor displays all entries matching the case-sensitivity of the first letter. Other available options include a case-sensitive match on all letters and ignore the case sensitivity.

Change Autocompletion 

1. On the Aqua Data Studio menu bar, click File > Options > expand AquaScript Editor  > click Auto Completion.
   
2. Perform the desired actions on the following settings and then click OK.
   
   • Enabled: This check box determines whether auto-completion is enabled.
   • Auto Popup: Select this check box to have Aqua Data Studio automatically show a code completion pop-up when appropriate. If this check box is not selected, then users can invoke the code completion pop-up window by pressing CTRL/Command+Space keystroke.
   • Auto Popup Delay: Specify the delay (in milliseconds) to have Aqua Data Studio pop up the code completion window.
   • Instant Substitution: Select this check box to have code completion perform instant substitution if the search result contains only one item.
   • Case Sensitive Matching: Select an option from the drop-down list to have Aqua Data Studio consider the case sensitivity when suggesting matches for auto-completion.
     • All: Case for all letters is considered. 
     • None: Case is never considered. 
     • First letter: Only the case of the first letter is considered.

Change Case Sensitive Matching

1. On the Aqua Data Studio menu bar, click File > Options > expand AquaScript Editor  > click Auto Completion.
   
2. Select the desired option from the Case Sensitive Matching drop-down list > Click OK.
   

Parameter Hint

Variable Highlighting

You can view usages of variable, function name or object in the current file when you place your cursor on any of these in the editor. All occurrences of the found usage will be highlighted, and marker bars will be displayed on the editor’s scroll bar. You can use these marker bars to navigate among the found usages. Hover on the marker bar to view the location of the highlighted usage.

Annotator

Annotator, also known as the status indicator, shows the status of the script as you type. 

•  indicates your script has errors. You can see the error count on mouse-hover and use marker bars for navigating between the errors. 
•  indicates your script is error-free.
•  indicates your script is being analyzed. 

Navigate to Next/Previous Highlighted Error

You can navigate through all errors displayed at runtime by using the Next Highlighted Error (F2) and Previous Highlighted Error (Shift + F2) commands of the Edit menu. 

HTML and XML Editors

Automatic Tag Closure

Auto-Update Tag Attributes

Aqua Data Studio supports auto-updating tag attributes. On updating the opening tag attribute, the corresponding closing tag attribute is automatically updated. For example, if you update <p> to <div>, the corresponding </p> tag attribute is updated to </div>.

Breadcrumb Trail

Image Viewer

The image viewer allows a user to view a list of images in a preview pane and operate on any selected image.

You can invoke the image viewer from the Grid Results of the Query Window. When the Convert Binary to hex option is unselected, you can view from within the Table Data Editor. You can unselect this option from File > Options > Results > Data Retrieval. A user may query a database for binary/image data and then load it into the image viewer. The image viewer supports GIF, JPG, and PNG file formats.

See Also

Code Insight and Code Completion Limits