Linker IT Software
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 ( newsletter Januari 2006 (Read 4148 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
LIT Software ( newsletter Januari 2006
06.01.06 at 16:00:49
LIT software newsletter -- -- 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
About the newsletter:
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.
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:
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.
Support for new databases:
New database types were tested with SQL*XL:
Active Directory:
Advantage DB Server:  
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.  
Support for report breaks:
Using the command "break on report skip n" you can skip a number of rows after each select statement.
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.  
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.  
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.  
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.  
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:  
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.  
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.  
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
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