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 srting is replaced with NULL
  TOP default size: TOP size selectiion 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.

• 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 wait time between transaction log used checks when log used is over threshold, 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 and body when compiling
  
  Determines if both the header and body are compiled when compile is executed

SQL Editor

• General
  
  Highlight matching brace: Determines whether matching brace is auto-highlighted
  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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  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 backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Forces a specific EOL (End of Line)
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository


• 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.
  Pane Maximum Size: The maximum size of the completion pane window.
  Pane Minimum Size: The minimum size of the completion pane window.
  Global Cache: Enables the Global Autocompletion Cache
  Include Synonyms in Completion: Enables synonyms in autocompletion
  Include Public Schema in Completion: Enables the public schema in autocompletion.


• Syntax Coloring
  
  Enabled: Determines whether Syntax Coloring is enabled
  Enable Bold :Enables bolding of text
  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
  
  Abbreviaton: 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.

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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  Editor Foreground Color: The foreground color for the Text Editor
  Editor Background Color: The background color for the Text Editor
  Highlighted Text Foreground: Highlighted text foreground color
  Highlighted Text Backgroud: Highlighted text backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository


• 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
  
  Abbreviaton: 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.

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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  Editor Foreground Color: The background color for the HTML Editor
  Editor Background Color: The background color for the HTML Editor
  Highlighted text foreground: Highlighted text foreground color
  Highlighted text backgroud: Highlighted text backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository
  HTML Tag Navigation Bar: Determines whether the HTML Tag Navigation Bar is enabled


• 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
  
  Abbreviaton: 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.

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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  Editor Foreground Color: The foreground color for the XML Editor
  Editor Background Color: The background color for the XML Editor
  Highlighted text foreground: Highlighted text foreground color
  Highlighted text backgroud: Highlighted text backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository


• 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
  
  Abbreviaton: 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.

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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  Editor Foreground Color: The foreground color for the XML Editor
  Editor Background Color: The background color for the XML Editor
  Highlighted text foreground: Highlighted text foreground color
  Highlighted text backgroud: Highlighted text backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository


• 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
  
  Abbreviaton: 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.

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.
  Line Numbers: Determines if the line numbers in the document are displayed along the left side of the window.
  Editor Foreground Color: The foreground color for the XML Editor
  Editor Background Color: The background color for the XML Editor
  Highlighted text foreground: Highlighted text foreground color
  Highlighted text backgroud: Highlighted text backgroud color
  Search Match Text Background: Highlited search match background color
  Matching Braces Background: The color used to match highlighting braces.
  Insertion Point Blink Rate: How fast the insertion point or overwrite caret blinks
  Insertion Point: Insertion Point Style
  Overwrite Caret: Style of caret when in overwrite mode
  Caret Color in Insert Mode: Sets the color of the caret when in Insert Mode
  Caret Color in Overwrite Mode: Sets the color of the caret when in Insert Mode
  Force Write EOL: Option for Editor to force a specific EOL [End Of Line] type
  Inline Diff Sidebar: Enables highlighting of differences with latest working copy from version control repository


• 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
  
  Abbreviaton: 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.


• 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.
  Pane Maximum Size - The maximum size of the completion pane window.
  Pane Minimum Size - The minimum size of the completion pane window.