Editor Options

Table Data Editor

•  Table Data Editor
  
  Transactions Required for Table Data Editor: Determines whether the Table Data Editor requires transactions. NOTE: If this is set to false, the Table Data Editor can’t guarantee single row modifications for row updates.
  Paste Transforms (null) String into NULL: Allows insertion of a NULL value when pasting a (null) string from the clipboard
  Prompt for Ambiguous Columns: If this value is true, the user will be prompted to identify the ambiguous columns, otherwise those columns will be read-only.
  Transform Zero Length String into NULL: Determines whether a zero-length string is replaced with NULL
  TOP default size: TOP size selection when selecting Table Date Editor in schema browser.
  Prompt user for TOP size: Prompt user for TOP size when selecting Table Data Editor in schema browser.
  Statement separator: Statement separator to use when generating DML scripts

• Transaction
  
  Transaction Type: Determines the transaction method applied to executed statements
  Batch Size: Determines number of statements per transaction. [Transaction Type: Batch]
  Threshold: Determines time limit threshold per transaction, milliseconds. [Transaction Type: Threshold]
  Wait Time: Determines the amount of time to wait between transactions, milliseconds. [-1 = Disabled]


• Transaction Log Monitor [Sybase ASE Log Monitor]
  
  Log Used Threshold: Determines the % of the Transaction Log used that will trigger a transaction wait time period. [-1 = Disabled]
  Log Used Wait Time: Determines the amount of time to wait between transactions when the Transaction Log Used has exceeded the usage threshold (in milliseconds).


• Modification Logs
  
  Enabled: Determines if modification logs are enabled
  Logs Location: Location where the modification logs are stored.
  Maximum Modification Logs: Maximum number of logs stored on disk before logs are truncated; no limit if negative

Procedure Editor

• Package Editor: Compile header & body when compiling
  
  Determines if both the header & body are compiled when compile is executed

SQL Editor

• General
  
  Highlight Matching Brace: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is.
  Highlight Caret Row Color: Highlight caret row color.
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  Display Text Limit Line: Determines if the text limit line is displayed.
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The foreground color for the Query Editor and results.
  Editor Background Color: The background color for the Query Editor and results.
  Highlighted Text Foreground: Highlighted text foreground color.
  Highlighted Text Background: Highlighted text background color.
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces
  Caret Blink Rate: How fast the caret blinks.
  Caret Style: Caret Point Style.
  Caret Color: The color of editor caret.
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled
  Show Code Folding Outline: Check this option if you want the code folding toggles to be shown in the editor. Uncheck this option to hide the toggles.
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar.
  Insert Pair Bracket: When an opening bracket is typed, automatically adds a closing bracket
  Insert Pair Quote: When an opening quote is typed, automatically adds a closing quote
  Insert Pair '}' on Pressing Enter: When Enter is pressed in an empty line, automatically positions a closing brace } at the proper column
  Auto Indent: Keep indents on empty lines


• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Auto Completion
  
  Auto Popup: Code completion window automatically appears when appropriate.
  Auto Popup Delay: How long to wait (in milliseconds) before automatically popping up the completion window.
  Instant Substitution: Code completion performs instant substitution if the search result contains only one item.
  Global Cache: Enables caching of completion information globally
  Include Synonyms in Completion: Enables synonyms in auto completion
  Include Public Schema in Completion: Enables the public schema in auto completion
  Case Sensitive Matching: Indicates the option to take into consideration the case sensitivity when suggesting matches for auto-completion.


• Syntax Color
  
  Enabled: Determines whether Syntax Coloring is enabled
  Enable Bold: Enables bold font for keywords
  SQL 92/99 Keywords: The color used for standard SQL 92 and 99 keywords
  Vendor Keywords: The color used for vendor-specific keywords
  Numerics: The color used for numbers
  Data Types: The color used for database specific data types
  System Functions: The color used for database specific system functions
  System Tables: The color used for database system tables
  Quoted Strings: The color used for single quoted strings
  Comments: The color used for commented text
  Aqua Commands: The color used for aqua commands


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  

Text Editor

• General
  
  Highlight Matching Bracket: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is
  Highlight Caret Row Color: Highlight caret row color
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  Display Text Limit Line: Determines if the text limit line is displayed
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The foreground color for the Query Editor and results
  Editor Background Color: The background color for the Query Editor and results
  Highlighted Text Foreground: Highlighted text foreground color
  Highlighted Text Background: Highlighted text background color
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces
  Caret Blink Rate: How fast the caret blinks
  Caret Style: Caret Point Style
  Caret Color : The color of the caret
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar
  Insert Pair Bracket: When an opening bracket is typed, automatically adds a closing bracket
  Insert Pair Quote: When an opening quote is typed, automatically adds a closing quote
  Insert Pair '}' on Pressing Enter: When Enter is pressed in an empty line, automatically positions a closing brace } at the proper column
  Auto Indent: Keep indents on empty lines
   
• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  

HTML Editor

• General
  
  Highlight Matching Bracket: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is
  Highlight Caret Row Color: Highlight caret row color
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  Display Text Limit Line: Determines if the text limit line is displayed
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The background color for the Query Editor and results
  Editor Background Color: The background color for the Query Editor and results
  Highlighted Text Foreground: Highlighted text foreground
  Highlighted Text Background: Highlighted text background
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces.
  Caret Blink Rate: How fast the caret blinks
  Caret Style: Caret Point Style
  Caret Color: The color of the editor caret
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled.
  HTML Tag Navigation Bar: Determines whether HTML Tag Navigation Bar is enabled
  Show Code Folding Outline: Check this option if you want the code folding toggles to be shown in the editor. Uncheck this option to hide the toggles.
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar.
  Auto Indent: Keep indents on empty lines


• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  

XML Editor

• General
  
  Highlight Matching Bracket: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is
  Highlight Caret Row Color: Highlight caret row color
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  Display Text Limit Line: Determines if the text limit line is displayed
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The foreground color for the Query Editor and results
  Editor Background Color: The background color for the Query Editor and results
  Highlighted Text Foreground: Highlighted text foreground
  Highlighted Text Background: Highlighted text background
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces
  Caret Blink Rate: How fast the caret blinks
  Caret Style: Caret Point Style
  Caret Color: The color of editor caret
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled
  Show Code Folding Outline: Check this option if you want the code folding toggles to be shown in the editor. Uncheck this option to hide the toggles.
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar.
  Auto Indent: Keep indents on empty lines


• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  

Java Editor

• General
  
  Highlight Matching Bracket: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is
  Highlight Caret Row Color: Highlight caret row color
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window.
  Display Text Limit Line: Determines if the text limit line is displayed
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The foreground color for the Query Editor and results
  Editor Background Color: The background color for the Query Editor and results
  Highlighted Text Foreground: Highlighted text foreground
  Highlighted Text Background: Highlighted text background
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces
  Caret Blink Rate: How fast the caret blinks
  Caret Style: Caret Point Style
  Caret Color: The color of editor caret
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled
  Show Code Folding Outline: Check this option if you want the code folding toggles to be shown in the editor. Uncheck this option to hide the toggles.
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar
  Insert Pair Bracket: When an opening bracket is typed, automatically adds a closing bracket
  Insert Pair Quote: When an opening quote is typed, automatically adds a closing quote
  Insert Pair '}' on Pressing Enter: When Enter is pressed in an empty line, automatically positions a closing brace } at the proper column
  Auto Indent: Keep indents on empty lines
   
• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  

Javascript Editor / AquaScript Editor

• General
  
  Highlight Matching Bracket: Highlight bracket that matches the bracket before the insertion point
  Highlight Caret Row: Highlight row where the insertion point is
  Highlight Caret Row Color: Highlight caret row color
  Status Bar Visible: Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  Display Text Limit Line: Determines if the text limit line is displayed
  Text Limit Character Count: Determines the character count after which the text limit line is displayed.
  Editor Foreground Color: The foreground color for the Query Editor and results
  Editor Background Color: The background color for the Query Editor and results
  Highlighted Text Foreground: Highlighted text foreground
  Highlighted Text Background: Highlighted text background
  Search Match Text Background: Highlighted search match background
  Matching Braces Background: The color used to match highlighting braces
  Caret Blink Rate: How fast the caret blinks
  Caret Point: Caret Point Style
  Caret Color: The color of the editor caret
  Line Separators for New Files: Specify which line separator is to be used for new files.
  Inline Diff Sidebar: Determines whether versioning inline difference sidebar is enabled
  Show Code Folding Outline: Check this option if you want the code folding toggles to be shown in the editor. Uncheck this option to hide the toggles.
  Show Code Lens on Scrollbar Hover: Shows the source code fragment when the mouse pointer is over the scroll bar.
  Insert Pair Bracket: When an opening bracket is typed, automatically adds a closing bracket
  Insert Pair Quote: When an opening quote is typed, automatically adds a closing quote
  Insert Pair '}' on Pressing Enter: When Enter is pressed in an empty line, automatically positions a closing brace } at the proper column
  Auto Indent: Keep indents on empty lines


• Tabs
  
  Expand Tabs: Determines whether a TAB is expanded to spaces or whether a real TAB is used
  Number of Spaces Per Tab: Number of spaces to expand in a TAB if Expand Tab is enabled
  Tab Size: The display size in characters of a TAB


• Abbreviations
  
  Abbreviation: The combination of characters used to trigger autocompletion of the Expanded Text
  Expanded Text: The text autocompleted when triggered by the abbreviation and following Expand On keystroke(s).
  Description: User-defined description of the Abbreviation’s functionality within the code.
  Expand on: Determines the key combination that expands the abbreviation.
  : Adds new abbreviation.
  : Removes existing abbreviation.
  : Moves abbreviation one place up in the abbreviation list.
  : Moves abbreviation one place down in the abbreviation list. 
  : Creates a copy of an existing abbreviation.  


• AquaScript Editor
  
  Maximum Number of Lines in Console: Determines the maximum number of text lines in the console.

• Auto Completion
  
  Enabled: Determines whether AquaScript Auto-completion is enabled.
  Auto Popup: Code completion window automatically appears when appropriate.
  Auto Popup Delay: How long to wait (in milliseconds) before automatically popping up the completion window.
  Instant Substitution: Code completion performs instant substitution if the search result contains only one item.
  Case Sensitive Matching: Indicates the option to take into consideration the case sensitivity when suggesting matches for auto-completion.