SQL*XL release log.
This document describes the releases made between version 4.1.12 dated 9/March/2007 and version 4.3.10 dated 7/Sep/2008. 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.3.10 (7/Sep/2008)

• Added advice message for corrupt MDAC (Microsoft data objects) installations.
  

 
SQL*XL 4.3.9 (9/Aug/2008)

• Added a hide note option to the Pivot Table target
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1217253490/0
  

 
SQL*XL 4.3.7 (22/June/2008)  

• Added the SQLFunction Excel function
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1213539102/0
  

 
 
SQL*XL 4.3.6 (9/June/2008)

• Added a Japanese translation.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1213011878/0
  

 
SQL*XL 4.3.2 (20/May/2008)  

• Removed all forms from sqlxl.xla, made sqlxl.xla smaller and hence quicker to load
  
• Support for substitution variables with the resultset_from_proc command
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1201723955/0
  
• Make create table SQL statements in the SQL editor
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1205749057/0
  
• Create a new table from the Multiple Rows Insert dialog
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1205785788/0
  
• New digital certificate valid until April 2010
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1206986663/0
  

 
SQL*XL 4.2.5 (03/Nov/2007)  

• Better support for the Oracle WITH clause
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1194123881/0
  
• Logging of warnings to the event log  
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1197897635/0
  

 
SQL*XL 4.2.4 (09/Oct/2007)

• Removed the maximum row limit of Excel (65k)
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1187878422/0
  
• Changed the SQLQueryValue worksheet function to also be able take a range of cells as the query parameter.  
  http://www.oraxcel.com/projects/sqlxl/help/functions/sqlqueryvalue.html
  
• Fixed problems when using locked/protected cells with the multiple rows insert feature.
  
• Recalculating SQL*XL functions are now added to the macro recorder and VBA.
  

 
 
SQL*XL 4.2.2 (3/June/2007)  

• Built in a SQL*XL tab in the Excel 2007 ribbon interface
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1176407093
  
• Some Excel 2007 problems fixed.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1169722188/0#2
  

 
SQL*XL 4.1.13 (16/March/2007)  

• Re-raising VBA errors after the SQL*XL errorhandling has been done.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1173954456/0
  
• Added a program preference to not show the SQL dialog for SQL favorites
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1174039192/0
  
• Fixed the column format command to take the format from another cell:
  column name format cell_address;
  
• Fixed problems with Oracle dates earlier than the year 100 with the OO4O driver.
  

 
 
SQL*XL 4.1.12 (9/March/2007)  

• Extended the clear command to be able to clear a cell range.
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1172403539#1
  
• New dll versioning.
  From this release all dlls will be versioned with the same number. For this release that will be 1.1.0.1.
  
• Better support for Windows XP SP2 (and for Vista)
  http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1173011951
  

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