Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
LIT Software (oraxcel.com) newsletter Januari 2006 (Read 4186 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
LIT Software (oraxcel.com) newsletter Januari 2006
06.01.06 at 16:00:49
 
LIT software newsletter -- http://www.oraxcel.com -- Januari 2006
 
The LIT software newsletter brings you the latest news about the software from Linker IT Software. You have registered yourself to this newsletter at www.oraxcel.com
About the newsletter: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1136557355
 
LIT Software Discussion Forums:  
The discussion forums are a great success. You can consult it for most of your questions. You can post your questions and reply to existing topics. A search feature allows you to find quickly what you need.
http://www.oraxcel.com/forums
 
The latest SQL*XL release:
SQL*XL 4.0.33 Universal is the latest release. It contains all the new features described in this newsletter and in the forums. If you have an upgrade subscription you will automatically receive a new release in the next few weeks. If you do not have an upgrade subscription but want to upgrade, please let me know.
We started a release log for SQL*XL which contains the details of what feature is in which new release and when the releases are made:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130772637
 
Translations:
We have started a project to translate SQL*XL into other languages. Approximately half of the SQL*XL front-end was translated so far and the work is ongoing. Current we support the following languages: Finnish, Swedish, Dutch, Spanish and Turkish. If you would like to help to translate the software please let me know. I can send a small spreadsheet with the texts to translate.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?board=sqlxl_translation
 
Support for new databases:
New database types were tested with SQL*XL:
IDB DB2 UDB: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1136392978
Active Directory: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1134487369
Advantage DB Server: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1131549951  
Firebird: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1128697723  
PostgreSQL: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1128525587  
 
Speed increase: Insert multiple rows
A 35% speed increase was realised in the Insert multiple rows feature. This was achieved by optimising the code and by refreshing the screen page by page.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135348306  
 
Support for report breaks:
Using the command "break on report skip n" you can skip a number of rows after each select statement.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135258076
 
Support for the set long command:
Using the command "set long n" you can define how many characters you want SQL*XL to print in a cell when a long (longvarchar) column is put in Excel. The default is 80.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135939951  
 
Support for Oracle timestamp fields:
Oracle timestamp functions can now be used with SQL*XL. These fields are different from normal date/time fields in Oracle. A timestamp is an object and that was the reason SQL*XL did not retrieve them correctly hitherto.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1134391429  
 
Support for -- comments and the layout of SQL is preserved:
It is now possible to use -- comments in SQL. You can now safely run statement where you comment out lines with a -- comment. The format of SQL statements is now also preserved. Previously SQL*XL would strip the carriage returns from SQL statements. Together with the support of the -- comments you can now truely experiment with SQL leaving the parts you don't want to use in comments.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1131534586  
 
Support for select statements in Stored Procedures in SQL Server:
Many stored procs in SQL Server return recordsets. This is visible when you run them from SQL Server's query analyser for example. Support was built in to SQL*XL to support this. When you run a SQL Server stored procedure that outputs one or more recordsets SQL*XL will put them in Excel.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1133182137  
 
The select as formula feature was fixed:
Select as formula can be used to output a formula into an Excel cell instead of a value. It makes it possible to store formula in the database. It makes it also possible to create Excel formula on the fly with SQL. Hitherto no spaces or commas were allowed in the formulas. This is fixed now:
www.oraxcel.com/projects/sqlxl/help/commands/asformula.html  
 
Prompting for substitution variables:
Using the accept command you can prompt for substitution variables you can use in your SQL statements. This allows additional flexibility for those who don't want to use bind variables (these are more complex) and those who do not want to use macro recording and VBA.
www.oraxcel.com/projects/sqlxl/help/commands/accept.html  
 
New Excel formula to run SQL: SQLExecute:
Using this SQL*XL Cell forumula you can run an SQL statement whenever the formula is calculated in Excel. You can use this formula to act as a trigger in Excel to notify a database.
www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130324093  
 
In litLIB, our Excel power functions library the following new functions were added:
HasFormula : Does a cell have a formula?
HasArray, WordCount, WordsLeft, WordsRight, WordsMid, PageNumber, PageCount
 
Best regards, Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com
Back to top
 
« Last Edit: 06.01.06 at 16:03:08 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1