Home Home Screenshots Download Documentation Contact Licensing

Documentation: Aqua Data Studio 4.7     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. Informix
  VII. PostgreSQL
  VIII. MySQL
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser & Scripting 
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Options
  VI. Settings
  Query Window
  I. Basics
  II. Shortcut Keys
  III. Toolbar
  IV. Server Side Comments
  V. SQL Automation
  VI. Variable Binding
  VII. Results
  VIII. Save Results
  IX. Auto-completion
  X. SQL Formatter
  XI. Permissions
  XII. Parameterized
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool

  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
Aqua Data Studio SQL History
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.

Home Screenshots Downloads Documentation Support Licensing Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved