SQL Excel

Hi Everyone,

FYI, later on today, I will copy up the new zip file with the new msi package for version 1.3.

The major changes in this version are

- Enhancement, added in an extra button in the main form to paste an embedded query into a worksheet. To the left of the button, is a text box and you need to type the name you want to assign to the embedded query in to the text box to enable the new button. The embedded queries have no dependency on the add-in - so it is just an easy way to set them up and then no dependency (you need to use the right click functionality to change them).

-Enhancement, changed the locatin of the settings/addin support file. Previously they were located in the same folder as the add-in (tpyically this was C:\Program Files\SQL Excel). This was bad design as mentioned in the forums. Now they will be located in a sub folder of "My Documents" [or the equivalent in your language].
The new location will be the equivalent of this
C:\Documents and Settings\USERNAME\Application Data\sqlexcel

- Bug Fix, fixed implementation of Excel 2007 limits. So for Excel 2007 you can paste in a bit more than 1 million records but for previous version you can only paste in a bit more than 64k. Same for columns, with Excel 2007 you can paste in over 1K but for previous versions only 256 columns.

- Bug Fix, fixed the version Check routine. Thanks Blitzoff ! The check did not work when the decimal seperator was not . [point]. So it would fail if the decimal seperator was , [comma].

- Bug Fix, fixed how scrollbars will display within the data grid on (when viewing a recordset in the main form).


There were a few other changes but I cant remember them exactly.
Will post up when the add-in is released later.
Thanks and have a nice day.
Al