PL/SQL Developer 5.1.6
======================

Installation
============
To install the software, simply run the included executable. It will ask you
for the product code that you have received from us. After this, all files 
will be copied to a temporary directory and the setup will be started.

If you are currently using a previous version of PL/SQL Developer, you do
not need to uninstall it. The setup program will replace all existing files.

Enhancements in PL/SQL Developer 5.1.6
======================================

* Oracle10g related fixes:
  > HTML documentation was not indexed correctly
  > Oracle Home was not correctly detected on an Oracle10g client
  > Explain Plan Window caused ORA-01986 errors
  > Debugger now requires DEBUG CONNECT SESSION system privilege
* Improved Direct Oracle Access Interface:
  > Fixed problem when returning more than 5 variables
  > Fixed possible lock when sending back modifications
  > Starting PL/SQL Developer from within Delphi/C++Builder could 


Enhancements in PL/SQL Developer 5.1.5
======================================

* Could not use LOB's or Objects on Oracle 10g
* Number precision would be incorrect on Oracle 9.2.0.4 and 10g
* Fixed IDE_GetPopupObject from Plan Window
* Fixed Command Window problem with quotes in comments
* Program Window preference "Ignore Unrecognized PL/SQL" added
* Displaying a collection column or attribute from a cursor result 
  set in a Test Window would lead to "Not logged on" error message

Enhancements in PL/SQL Developer 5.1.4
======================================

* Multi-Monitor support added
* Selecting an item with username and password from the list will now
  immediately connect
* Fixed several Access Violations
* Edit > Redo would redo all changes
* Command Window fixes:
  > Help command now uses html help (or supported commands for help ?)
  > When executing a command file from the clipboard, Echo would always be on
  > Timestamp values could not be queried
  > Executing commands in dual or single session mode while another window is
    running would cause hang-up
* Code Assistant fixes:
  > Did not use original case for local constants and program units
  > Would remove spaces and tabs until the next word on the same line when
    inserting text
  > Limited to 1000 items to prevent performance issues
* Crash recovery fixes:
  > Application title would not be correct
  > Maximized windows would not be restored correct
  > Suppressed redrawing of window list when saving recovery files
* File > New Instance no longer passes userid parameter
* Report Window would always have all edit menu options enabled, unrelated to
  selected tab page
* Program Window "Clear Errors" now also clears highlighted error line
* Editors would not see text drag & drop as a change
* Result grid in SQL Window would allow cut and paste, even if locked
* Fixed setup problem on multi-monitor systems
* Saving a file under another name within a project, did not enable
  "add to project" menu item
* Fixed report problem when sum per break would coincide with pagebreak
* Disabled Export items while exporting
* Test Window would not show output when package state is discarded
* Joined substitution variables (&var1&var2) would not be processed correctly
  in SQL Window, Report Window and Command Window
* Generating a Test Script for a method with a collection attribute would
  result in incorrect PL/SQL
* Library did not contain trailing / when exported, which would cause an error
  when the generated script is executed through SQL*Plus
* Selecting a SQL statement including the trailing semi-colon could cause
  ORA-00911 error
* Fixed "Beautifier caused an error" for alias[space].field expression
* Bookmarks and breakpoints would disappear when using the PL/SQL Beautifier
* Code Contents could fail for concatenated case expressions
* Fixed erroneous cursor down key behavior on last line in editors
* Fixed grid copy issue for specific international (Greek) fonts
* Fixed case sensitivity issue for custom keywords (international characters)
* Added some missing Paste items in popup menus
* Passwords that start with a numeric character are now automatically quoted
* Adding a variable to the watch list while the debugger is executing a step
  caused a crash
* Job interval field was inadvertently limited to 61 characters
* Program Window name tab was not always correct for packages and types
* Improved Copy/Paste in Grid in single record view
* Not all dialogs supported [Enter] and [Esc]
* When changing Reports or Documents, the main menu items could get reorganized
* Logon history list could have the "Remove" option from the popup disabled
* Record/Object assignments could cause incorrect "Unused value assignment"
  hint
* Excel export now declares strings to prevent interpretation by Excel

Enhancements in PL/SQL Developer 5.1.3
======================================

* Edit button added to description in layout section of Report Window
* Bookmark Next/Previous menu added (with shortcut)
* Load and Save button added to Text Editors
* SQL Window Single Record View now allows sorting
* Query Builder did not update where clause after drag & drop a column name
* Fixed "cursor down at end of editor" issue
* Special Copy definition now has #define to control string character
  replacement
* Toolbar buttons for external tools did not get enabled/disabled
* Export Tables grid did not sort on dates correctly (incorrect date format)
* Substitution variables had to be declared in order of usage
* Secondary substitution variables did not inherit properties from the primary variable
* Switching to Single Record View with a function key in the SQL Window would
  not size the column widths correctly
* Code Contents fixes:
  > Could not handle variable declarations with case assignment
  > Could not handle language keyword in declarations
  > Could not handle nested case expressions
* PL/SQL Beautifier fixes:
  > Numbers that start with a decimal point (eg .13) would not be formatted
    correctly
  > Table.* would not always be formatted correctly
  > Secondary select statements from a Union, Minus or Intersect would be
    incorrectly indented
  > Could not handle language keyword in declarations
  > Keyword followed by string without a space would cause error
    (e.g. execute immediate'select * from dual')
* Command Window could not connect when userid command-line parameter was
  specified
* SQL Window would set focus to grid when switching tab pages
* Warning for Update or Delete all records now occurs only once
* In Multi-Session mode the AfterConnect.sql script would cause serialization
  of the first execute of SQL Windows, Test Windows, and Command Windows.
* Canceling a debug session with an infinite loop could cause hang-up
* Large collections (> 1000 elements) could not be viewed in debugger. They
  are now truncated to 1000 elements, and a warning is displayed.
* XML Export could not handle column names with invalid XML name characters
  (e.g. # and $)
* Fixed cursor left en right 'lock' in single column grids
* Command Window now supports PlugIn command to call Plug-Ins
* Initial object query in Export User Objects and Export Tables could not be
  cancelled
* Table could not be described when using a join keyword in a select statement

Enhancements in PL/SQL Developer 5.1.2
======================================

* Post changes button in SQL Window was not enabled when cell button was
  clicked to make a change
* Lookups for check constraints in SQL Window included quotes for character
  values
* Lookups for check constraints and foreign keys in SQL Window enabled in QBE
  mode
* F4 could not be used as a function key in the Object Browser
* DDL incorrect for views with check option without constraint
* Case insensitive search did not work with national characters
* Debugger did not display empty string variable values
* PL/SQL beautifier did not format collection element fields correctly
  (coll(index).field)
* Delete records option of Import Tables tool was not remembered
* Subsequent && pairs (escaped substitution variable prefix) would be replaced
  by one &
* && in substitution variable value would be replaced by &
* Printing HTML with Internet Explorer viewer now without header, footer and
  with correct orientation
* Fixed several Access Violation errors
* Plug-In interface updated and documented

Enhancements in PL/SQL Developer 5.1.1
======================================

* New SQL Window preference: Show Dictionary Info In Result Grid:
  > Column data type, optionality, and comment displayed
  > Lookup for check constraints (col in (value1, value2, ...))
  > Lookup for single column foreign key constraints to small tables of less 
    than 1000 rows
* Added option to save backup files in a specific location
* Added Save & Load Object Selection to object grids (Export User Objects,
  Export Tables, Compare User Objects)
* AfterConnect.sql in PL/SQL Developer installation directory will be executed 
  after connecting a session
* Hints & Warnings can now be cleared in Program Window
* Post Changes button in SQL Window is now disabled when there are no changes 
  to post
* Export in Oracle Export format no longer deletes parameter file in TEMP 
  directory
* Added PlugIn functions IDE_TabInfo() and IDE_TabIndex() to read and set Tab 
  pages
* Connection Indicator Editor background did not work properly
* Excel interface did not handle formatting of numbers correctly
* PL/SQL Beautifier fixes:
  > Caused error for multi-line string parameter values
  > Did not format table list correctly in select statements
  > Uppercase did not work properly for special characters
  > Comments with unterminated strings would be incorrectly indented
  > Object Type attribute declarations were not aligned
  > Single line selection was not indented correctly
  > Did not work correctly on Windows 9x
  > Expressions in insert list items were not always formatted correctly
* Compiler Hint fixes:
  > Record/object assignments could lead to incorrect unused value hints
  > Nested if/then/else could lead to incorrect unused value hints
  > Duplicate variable names in a program unit would cause unused declaration 
    hint
  > Variable names prefixed with program unit name would cause unused 
    declaration hint
  > Incorrect unused value hints when using variables after an exception
* Fixed several Access Violation errors
* Fixed some memory leaks
* Descending function-based indexes would show up ascending
* Find dialog: paste/cut/clear did not work when invoked for a read-only editor
* Copy to Excel did not handle duplicate column names properly
* Editor Special Copy fix Visual Basic: vbNewLine replaces vbCR
* Long (Raw) columns could not be queried when varchar(2000) or longer was 
  included
* Code Assistant "overload" buttons were not always positioned correctly
* Original command-line parameters are now passed to New Instance (File menu)
* Leading and trailing spaces in table/column comments would be removed in 
  Table Definition Editor
* Query Builder would cause AV on "Find Databse Object" Window
* Help button incorrectly appeared for non-Oracle error messages
* External Tools "Save Window" option was not stored

Enhancements in PL/SQL Developer 5.1.0
======================================

* PL/SQL Beautifier added
* Localization functionality added (Japanese version available, other 
  languages will follow)
* Compiler Hints added for unused declarations, unused value assignments,
  comparison with NULL, function without return, and to_date without format
* Code Assistant can now use original case for inserted parameters, functions,
  and so on
* New Code Assistant preferences:
  > Describe standard functions (e.g. to_char)
  > Use original case if possible
* Backup and recovery options added for editor files
* Toolbar button options added for External Tools, Macros and Documents
* Copy to Excel added for SQL Window and Test Window result grid
* SQL Window preference "Date & Number fields to_char" split into 2 preferences
* Special Copy function to convert SQL to 3GL strings
* Command Window enhancements
  > Support for WHENEVER SQLERROR | OSERROR added
  > Pause execution to single step through a script with command highlighting
  > SET EXECPAUSE ON | OFF added to control pause mode from script
* Report Window enhancements
  > Export results to XML, CSV, TSV, or directly to Excel
  > System variables in report title (&dbuser, &database, ...)
  > Added Format option for number and date fields
  > Added LIBRARY parameter to select report style library file
  > SQL Text can be included in the HTML output
* Connection Indicator can now be applied to editor background or application
  background
* Export options for Statistics in SQL Window and Test Window
* Find Database Objects now also supports the Job object type
* Query button added to Table Definition Editor
* More robust Oracle Home selection
* Debugger preferences "Never/Always add debug info" now support connection
  matches (e.g. sys@*)
* Compare User Objects now ignores white space in PL/SQL source
* Support for Interval datatype added
* Timestamp and Interval datatypes supported in Export/Import table data
* Text Editor can now view text as formatted HTML
* Option in template to add brackets (using double brackets [[ or ]])
* Many other minor improvements and bugfixes

