SQL*XL release log.
This document describes the releases made between version 4.0.41 dated 10/March/2006 and version 4.1.11 dated 27/Feb/2007. For the most current release please see: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130772637
For a description of the SQL*XL program see http://www.oraxcel.com/projects/sqlxl

 
SQL*XL 4.1.11 (27/Feb/2007)

• Added Oracle database session tagging; module=SQL*XL.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1169674022/0
  
• Improved SQLQueryValue worksheet function. Prevented function errors and added transpose option.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1171380550/0
  
• Added better support for stored procedures in SQL 2005 Express
  

 
SQL*XL 4.1.9 (24/Jan/2007)  

• Added settings to define the default parameter data type and direction.
  
• Refresh queries in worksheet or workbook.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1169567392/0
  

 
SQL*XL 4.1.8 (22/Jan/2007)  

• Added Excel files (xls files) to the Connection Wizard.
  
• Allow to connect to a saved connection by double clicking.
  
• Built in support for the SQL*Plus show command.  
  http://www.oraxcel.com/projects/sqlxl/help/commands/show.html
  
• Built in support for the SQL*Plus set escape command.
  http://www.oraxcel.com/projects/sqlxl/help/commands/set.html
  
• Support for parameters in strings.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1167392923/0
  
• Support for the execute SQL*Plus command.
  http://www.oraxcel.com/projects/sqlxl/help/commands/execute.html
  

 
SQL*XL 4.1.4 (31/Oct/2006)  

• SQLQueryValue can be used to display more than a single value. It is an array formula now.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1162290970/0
  
• Support for ; list separator in the multiple rows insert dialog.
  

 
SQL*XL 4.1.2 (24/Sept/2006)

• Added a menu item in the SQL editor to convert text to lower or upper case.
  
• Added validation in insert and update functions for cells in error (#Ref, #DIV0, etc).
  
• Tabs are allowed in the SQL editor.
  
• SQL editor generates select statements with where, group by and order by clauses:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1157961469/0
  
• Fix to allow ADO connections be made with the connect command:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1157964436/0
  

 
SQL*XL 4.1.1 (29/July/2006)  

• Added a database connection wizard:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1154198642/0
  
• Added the possibility to configure a connection to an Access database that uses an MDW information file.
  
• Better error handling in single row insert:
  On insert errors a fatal exception was received and SQL*XL was for security reasons logging off the database. Now a the error message is displayed only.
  

 
SQL*XL 4.0.49 (18/July/2006)

• Better VBA support for Multiple Rows Update:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1151420017/0
  

 
SQL*XL 4.0.46  

• Support for visoe.dk XML provider:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1143212771
  
• Support for Intersystems Cache:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1143815666
  
• Support for Intuit QuickBooks through QODBC:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1143819856
  
• Better support for parameters when recording macros:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1144243580#1
  
• SQL*XL Activity Logging:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1148027622
  

 
SQL*XL 4.0.43 (22/March/2006)  

• Support for Oracle subquery factoring; the with clause
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1142498392
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1142498970
  
• Allow field values to be saved as files through VBA
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1142593105
  

 
SQL*XL 4.0.41 (10/March/2006)  

• Added the syntax to the variable command to size a text bind variable.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1140791693  
  http://www.oraxcel.com/projects/sqlxl/help/commands/variable.html  
  
• A new function was added to create SQL insert statements from data in Excel:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1141295783
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1141297266
  
• A set of worksheet functions are added to SQL*XL. A new menu item is provided to create these functions: Insert Function. This menu also contains calculation commands:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1141398445
  
• Some screens were translated into Czech:
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1141654262
  
• About 10% of the Simplified and Traditional Chinese translation was changed
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1138696813
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1138696791
  

 
Release log covering versions 4.0.26 - 4.0.40: http://www.oraxcel.com/projects/sqlxl/releaselog1.html