Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager

SQL History - Aqua Data Studio includes an SQL History feature which provides a history of all SQL statements and scripts that have been executed. The SQL History dialog can be activated by clicking on the SQL History toolbar button. The history window does not need to be closed to continue working on your queries, and may run side-by-side with the main window.

The SQL History window provides a list of previously executed statements and the ability to select any statement into the current Query Window. The 'Max History' sets the maximum number of sql commands stored in the history. The 'Max Statments Per Entry' sets the maximum number of statments stored in a history entry. If the 'Max Statements Per Entry' is set to 5 and a script of 100 statements are executed only the first five would be stored with that entry.

The 'Date' column show the time the query was executed. The 'Server Type' indicates on what type of database server the query was executed on. The '# Stmts' shows how many statements are stored in that entry.

SQL History Enhancements

  • General
    • Now provides a preview tab that displays the full SQL that is currently selected in the history list. This preview may be enabled/disabled on the toolbar.
    • Column size and window position are now saved and reloaded when application is restarted.
    • Date column is now formatted according to the locale.
    • Added columns "Server Name", "Tool name", "Start Date/Time ", "End Date/Time ", "Rows Affected" to the SQL History.
    • Columns are now sortable.
    • File>Options:[General:SQL History] Added SQL history options "maximun number of entries" and "maximum number of statements" to determine persistance values, even though values may be temporarily changed in the SQL History dialog.
    • Added to the toolbar a Quick Filter panel to filter the history
    • Added Alt-M hot key to focus on the Max History field, Alt-S to focus on the Max Statements per entry field, Alt-Q to focus on the Quick Filter field. Press "Escape" to regain focus on the table.
    • Added a "Diff" button to the toolbar. If a user selects two rows and clicks on this button, the application will open a Diff Tab for the two SQL Statements to compare them.
  • " Find" functionality for both the Grid list and Preview Panel
    • "Find": Find the first occurance of the text in the grid values starting from the current position
    • " Find Next": Find the next occurance of the last find
    • "Find Previous": Find the previous occurance of the last find

 
Aqua Data Studio SQL History
Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved