Version
1.7.278.1
Created on
6.3.2017. 16:32:31 (UTC)
Md5
9ffcce9abf93f12856af8f2447abb28d
What's new
Fixing two important issues:
- When another Excel plugin uses SQLite (i.e. Google drive addin), it would clash with QueryStorm and result in an error when trying to connect using the built in engine.
- The UI would occasionally crash when loaded, resulting in the editor and object explorer only partially rendering.

Version
1.7.277.1
Created on
14.2.2017. 16:36:49 (UTC)
Md5
302adc6f16e4e51ad21cd48251e85d14
What's new
Fixing a bug with LiveMode that prevents queries with certain types of joins from executing

Version
1.7.276.1
Created on
12.2.2017. 22:58:35 (UTC)
Md5
bac805fb148a03680e0b3b807b1f64ac
What's new
Fixing editor find/replace issues 
Fixing marginal installer issue

Version
1.7.275.1
Created on
9.2.2017. 16:35:14 (UTC)
Md5
8d4f860c39c93dcee57782f5c253a4ea
What's new
Fixes
=====================
- Slightly improving results viewer performance
- Related-Queries context menu now opens properly via keyboard as well
- Fixing quoting for columns that start with digits
- Various misc fixes
- Fixing editor find/replace dialog issues

New features
=====================
- Visual upgrade of full window mode
- Preprocessor - defining variables (e.g. :{abc=3})
- EmbeddedQueries - new button: duplicate query
- Connections - new buttons: move up/down, duplicate connection
- New live-mode scalar functions: Concat, RefreshPivotTable
- New live-mode tabular function: RandomGauss, XLCells
- New context menu: QuickQueries
- New quick queries: Replace in selection, Replace in column

Version
1.7.274.1
Created on
30.12.2016. 19:44:21 (UTC)
Md5
693b1be381c4ae3273aeb72e04f3ec24
What's new
Fixing a licensing issue

Version
1.7.273.1
Created on
18.12.2016. 19:55:34 (UTC)
Md5
f2ed3f9df11e86e375b0a327030272d9
What's new
Updating licensing library. 

Version
1.7.272.1
Created on
16.12.2016. 11:48:10 (UTC)
Md5
231874517a4ffa00fb75d8ca0d002f1e
What's new
Fixing the plugin behavior for errors that happen when loading (preventing the plugin from being automatically disabled on error, showing error message instead).

Version
1.7.271.1
Created on
14.12.2016. 17:49:07 (UTC)
Md5
2f09e2de90c9c74eeacb802672d4f59c
What's new
New functions
============
- OADate: turns a date into its OADate representation (Excel's way of storing datetime values)
- ParseDateTime: parses a string as a date, using the specified custom format

Version
1.7.270.1
Created on
5.12.2016. 11:52:50 (UTC)
Md5
8a36fbb7b4026dc3b024d74bc4588a1d
What's new
Fixes
============
- fixing an issue when updating tables with datetime columns that have nulls
- fixing an issue with the dock settings not being saved

Version
1.7.267.1
Created on
29.11.2016. 19:26:25 (UTC)
Md5
90eec7ed5672560e20c186e6d44164b4
What's new
- Fixing installer (now properly detects vstor and installs if missing - for Office 2007 and 2010)
- Added "Dock" button while in full-window mode.

Version
1.7.266.1
Created on
24.11.2016. 13:13:51 (UTC)
Md5
84da8d2c7ababfed23af09c7214b1464
What's new
Window (undocked) mode
================================
- IDE now has the ability to dock into its own window for more convenient querying and result analysis, especially for multiple displays.
- Window/docked modes each have their own layout, so you can modify their layouts independently.

Know issues
================================
- Docking panes into the documents region will not work properly (will not get restored correctly). Dock your panes to the edge of the document container, rather than with/next-to  the document region.

Version
1.6.265.1
Created on
14.11.2016. 11:30:09 (UTC)
Md5
ac1f62bbd19c1bc1e716aae871b3f12f
What's new
- Fixing issues with the installer.
- A few misc fixes and improvements

Version
1.6.264.1
Created on
27.10.2016. 12:42:53 (UTC)
Md5
85762a08116b05e302a50ccc85ab6619
What's new
Live mode - new features
================================
- New table valued functions - generate_series, unpivot, regex_split
- QuickQueries for using "unpivot" and "regex split"
- Ability to use VBA functions (that return 1D/2D arrays and Collections) as table-valued-functions inside SQL queries.

Demo:
Workbook demonstrating the use of the new features can be downloaded from http://www.querystorm.com/downloads/demo_tvf.xlsm

Notes:
- You'll need to enable macros for the queries in the demo workbook to work. 
- See the VBA editor (Alt+F11) to check out the VBA side of the interaction.

Version
1.6.263.1
Created on
19.10.2016. 16:28:10 (UTC)
Md5
7b222511a33d3fe7a52554c2aecbbcb3
What's new
A rework of licensing
=================
Not a huge rework and has little to do with QueryStorm itself. None the less, for technical reasons it is a required update for all new licenses (not mandatory if you have an existing valid license). The reason for the update is that the licensing infrastructure is getting completely separated from QueryStorm so it can be reusable for all .net applications.

Version
1.6.262.1
Created on
4.10.2016. 10:24:47 (UTC)
Md5
85f71b08773f99178021dd7df5dcdba2
What's new
Fixes
=============
- fixed writing datetime values to Excel
- fixed a bug with the custom connection dialog

Live/SQLite
=============
- new table-valued function: generate_series(int start, int count)
- new function: FormatDatetime

Version
1.6.261.1
Created on
21.9.2016. 10:17:56 (UTC)
Md5
7e7805370c792fca8f2df964f4fce63a
What's new
Fixing issue with saved connection strings for engines of the same type

Version
1.6.260.1
Created on
3.8.2016. 9:52:20 (UTC)
Md5
411f4b268014263d9b763e2577323d45
What's new
Migration: ThingieQuery --> QueryStorm. This update is a migration path from ThingieQuery to QueryStorm. This is only a name change, ThingieQuery has been renamed to QueryStorm. All ThingieQuery licenses will continue to work with QueryStorm.

Old name versions (ThingieQuery)

Version
1.6.262.1
Created on
21.9.2016. 10:17:56 (UTC)
Md5
7e7805370c792fca8f2df964f4fce63a
What's new
Migration update: ThingieQuery --> QueryStorm. This update is a migration path from ThingieQuery to QueryStorm (project renamed). This is a cumulative update from the last version of ThingieQuery to the newest version of QueryStorm. Note: all ThingieQuery licenses will continue to work with QueryStorm.

Version
1.5.259.1
Created on
28.7.2016. 19:45:47 (UTC)
Md5
312ad759616fc1447479b4e9f351caeb
What's new
Fixing issue with embedded query subfolders, and some other minor improvements and fixes.

Version
1.5.258.1
Created on
25.7.2016. 19:25:02 (UTC)
Md5
0899e1c52418f68b9f74d9d7888539ef
What's new
New features
=============
- QuickQueries: new ribbon button + UI for generating/running queries for common tasks. 
- SQLServer inline table valued functions supported in objectexplorer and autocomplete
- New global shortcuts (will work regardless of focus/selection in Excel, keys changable in "settings" dialog)
	- connect to workbook: Ctrl+Shift+T
	- connect custom: Ctrl+Shift+C
	- quick queries: Ctrl+Shift+Q

Breaking changes
===================
- Dealing with multiple open workbooks: prefixes are eliminated altogether, if two tables have the same name, only one will appear (priority to the active workbook).

Fixes
===================
- Fix for phantom (invisible) text in editor
- Fix for triggers not being saved
- Various misc fixes

Version
1.5.257.1
Created on
13.7.2016. 17:02:34 (UTC)
Md5
2ba6c69edd9be48efc27610faefd3d67
What's new
Improvements
- All engines can now use tables from multiple open workbooks
- When using tables from multiple workbooks, table names are prefixed only when required (two tables with same name)
- Many misc improvements and fixes

Redesigned "Connect custom" dialog
- stored connections are now shown as a list, and engine type is shown as a dropdown (much more user friendly)
- tree for selecting tables to import

Redesigned "Object explorer" pane
- queries can be organized in a tree, as opposed to a list
- context menus, shortcuts and tooltips

Version
1.5.256.1
Created on
25.6.2016. 11:28:58 (UTC)
Md5
ca059b99cb14f08080b36a54c65a53bf
What's new
Upgraded to new licensing infrastructure (movable licenses!)

Version
1.5.255.1
Created on
30.5.2016. 17:18:14 (UTC)
Md5
485df086ad37b26ec03cc461bd3817ce
What's new
- Fixing a bug with the preprocessor (the @ sign was interpreted badly when not at beginning of line)
- Renamed two functions: SetBackgroundColorRGB and SetFontColorRGB (removed RGB from name)

Version
1.5.254.1
Created on
21.5.2016. 10:22:46 (UTC)
Md5
7aa62e2ce75afc5d89e20a327df5e3bf
What's new
1. Several stability improvements and bugfixes.
2. New function "EqNoCase" - case insensitive comparison of two parameters.

Version
1.5.253.1
Created on
17.5.2016. 15:06:46 (UTC)
Md5
1b148d853b0b42b304925d49079e9a1f
What's new
Bugfixes and stability improvements

Version
1.5.252.1
Created on
12.5.2016. 16:02:19 (UTC)
Md5
7b0d81c3a02952f21e1b9c52fb4248b5
What's new
Updater window no longer a nuisance
==============================
- The updater window no longer pops up. Instead, a button shows up in the ribbon allowing you to update at your leisure.

Editor improvements
================
- Better editor support for MySql, ODBC and Access

Engines
================
- Access engine fixed (was broken in last few versions)
- Postgres engine now plays nicely with Redshift

Performance
================
- Performance of Live mode when reading datetime columns improved by an order of magnitude.

Other
================
One or two miscellaneous fixes

Version
1.5.251.1
Created on
10.5.2016. 16:17:47 (UTC)
Md5
2aa3314372e9295a473d622a97406be3
What's new
Features
=================
Function overloads showing in the function insights tooltip

Misc
=================
Postgres engine few tweaks
SQLite extensions enabled (e.g. FTS4)

Fixes
================
DateTime error for cultures that use "." between hour and minute 
Licensing dialog size issue

Version
1.5.250.1
Created on
3.5.2016. 19:41:25 (UTC)
Md5
3f52fd9cdfaf83c1bdafea00a88e45f6
What's new
- Upgrading to .NET 4.5.2, fixes intermittent visual issues
- Fixing a number of Automation issues
- Search/Replace in editor (Ctrl + H)
- Various miscellaneous improvements and fixes

Version
1.5.249.1
Created on
30.4.2016. 12:28:42 (UTC)
Md5
0434a63d4948da6ca8bbe31ba3ba6d08
What's new
Upgrade for PostgreSQL
=====================
- Views and functions in object explorer and auto-complete
- Using SQLite parser until the proper PostgreSQL parser is completed (with error indicators disabled)
- Connect timeout disabled (user can always cancel manually)

Fix
=====================
- Fixed behavior of live mode when types of table columns are changed while connected

Misc
=====================
- context menu for named ranges improved (uses name of range instead of address when setting triggers)

Version
1.5.248.1
Created on
26.4.2016. 16:26:39 (UTC)
Md5
e99c6a5b82937cdcac1dd877acad6f30
What's new
Performance improvements
=====================================
- improved data read performance for both modes (~ 3x)
- live mode: improved connect times (~5x), memory footprint reduced (to 1/3)
- indexes in live mode also used when searching ranges

New live mode functions
=====================================
- StDev 
- StDevSample
- ElementAt
- GetTableRangeAddress

Other
=====================================
- Upgraded to latest version of SQLite
- Log messages don't show internal stuff anymore
- Columns with multiple datatypes colored orange in object explorer to denote issue

Version
1.5.247.1
Created on
15.4.2016. 18:53:13 (UTC)
Md5
cf523260fbeabfbcf297a80464a416f9
What's new
Important fix:
================
- storing and fetching of all settings fixed! (list of connections, sizes and locations of windows, settings...)

Changes:
================
- fixed missing "Event" property on TableTrigger UI
- introduced new column into all tables "__row" (hidden in SQLite but still present, just like __address)
- table writer now remembers the last value for DefaultTableStyle
- function insights show an examples button (top right corner): tooltip displays example, clicking copies the example to the clipboard
- levDist now has an optional maxdiff parameter to improve performance
- gpsdist function can accept all numeric types as parameters

Version
1.5.246.1
Created on
6.4.2016. 14:37:20 (UTC)
Md5
ad74a4f4f3f9e1ad6ee7dee91cd5dcc8
What's new
!!! Emergency fix for bad installer (missing file in the installer), version 245 installer is not valid and will not work for external databases. !!!

Version
1.5.245.1
Created on
4.4.2016. 12:19:55 (UTC)
Md5
294fd8212decbbaad84dfbfd3a758ff7
What's new
Editor: full code analysis features for TSQL (Ms Sql Server)
============================================================
- syntax highlighting specific for TSQL
- underlining errors (syntax errors, undefined symbols, ambiguous symbols)
- smart autocomplete (context sensitive, understands aliase, scopes, dynamic objects such as derived tables, CTEs, variables, cursors etc...)
- tooltips for all symbols
- star expansion (ctrl+space on star)
- disambiguation (ctrl+space on ambiguous symbol)
- autoformat (ctrl+shift+enter)
- table value functions visible and fully supported

New engine type
===============
- ODBC engine: does not support importing Excel tables as temp tables as there is no support for temp tables in ODBC

Live mode
=========
Functions renamed:
	- SetRangeColor -> SetBackgroundColorRGB
	- ClearRangeColor -> SetBackgroundColor
	- SelectCells -> SelectRange
New function: 
	- Proper (converts input text into Proper Case)
	- SetBackgroundColor (like SetBackgroundColorRGB but accepts the color by name)
	- SetFontColorRGB
	- SetFontColor
Changes:
	- Eval func parameters are not 0-based for consistency with other functions

Other
=====
- stability improvements for live mode (for situations when user manually modifies or moves tables while connected)
- fixed (automation) context menu issues when multiple Excel windows are open, new context menu items added
- several misc fixes

Version
1.4.244.1
Created on
17.3.2016. 14:05:05 (UTC)
Md5
c1873d814ce172aaa51dc086b531e0c9
What's new
New features
==========================
- new type of trigger: ButtonTrigger (ActiveX), buttons can be used to trigger execution of embedded queries without using VBA
- New context menus for setting up automation (new context menu items for tables/cells/buttons)

Misc code/stability improvements and bugfixes

Version
1.4.243.1
Created on
10.3.2016. 18:36:43 (UTC)
Md5
85f5dde68218e5862fe2cb1917126035
What's new
Patch: fix issue with ThingieQuery dialog windows for Office 2010

Version
1.4.242.1
Created on
10.3.2016. 12:46:31 (UTC)
Md5
aa2f287550ea82c3e7639a3482aacf47
What's new
General news and improvements
- improved preprocessor (can use all sorts of expression in {} blocks)
- can autodetect cell references in {} blocks and automatically set them as triggers for re-running queries
- fixed multiple "write results" context menu item
- all command timeouts are now disabled, this was pointlessly stopping people from running long-running queries
- bugfixes and improvements in stability

Breaking changes
- TableWriter property has changed: EmbedQuery -> SetupRefresh. This is done because it now has three values (No, Manual, Automatic) and the new name more accurately describes what it's for. This change will break existing scripts that set the old property (should be very easy fix though).

Live mode changes
- new functions: SetRangeColor, ClearRangeColor, Eval (for running C#-like expressions, a lightweight alternative to calling vba functions)
- can autodetect excel table references in sql queries and automatically set them as triggers for re-running queries
- the ability to call the random function with parameters (e.g. random(1,100), previously you could only call it without parameters)

Results pane changes
- if you double click on a cell in the results grid that has an Excel address inside it, that range will be selected in Excel
- if the selection in the grid includes cells that have Excel addresses inside them, and press space it will select all the ranges in Excel that the adresees refer to

NOTE: The code signing certificate is renewed (the old one expired), this means the first few users who install might get a warning prompt from Windows. This is normal, and will likely only show up for the people who download in the first few days (until the cert builds trust with windows smartscreen) but might be make it impossible for people without admin rights to install it until then. If you are one of them, please try again in a day or two, it should work fine then.

Version
1.4.241.1
Created on
13.1.2016. 13:57:42 (UTC)
Md5
73f60ffa688af16d1680a3a0ceccc448
What's new
Editor improvements (for Live mode only currently):
==========================================
- star expansion: when caret is at star, you can replace the star with a list of columns it includes by invoking auto-compete (Ctrl+space)
- disambiguate symbols: when caret is at ambiguous column, you can invoke auto-complete (Ctrl+space) to choose the appropriate prefix for the column
- editor highlights matching quotes, case-end and when-then pairs; also you can toggle cursor position between them using Ctrl+]
- editor supports auto-formatting of the SQL query, default shortcut is Ctrl+Shift+Enter
- function insights: while entering function parameters an "insights" tool-tip is displayed showing the description of the function and the descriptions of the parameters
- descriptions of functions are also shown in auto-complete

Automation:
===========
- New trigger types: Timer and RangeChange 

Misc:
======
- 3x performance increase when connecting to workbook (noticeable only when working with large tables though)
- New buttons to select/deselect all tables when connecting to external database
- When writing results as table text columns now explicitly set the formatting to be "@" so if a text value "looks" like an int it still gets treated as text regardless (leading zeros issue)
- several smaller improvements and fixes

Version
1.4.240.1
Created on
9.12.2015. 14:25:47 (UTC)
Md5
e75a974dd5323079d600e8344187b016
What's new
Query editor improvements
==========================
- Smother code completion (SQLite -> i.e. Live mode)
- Font size can be changed in the editor using "Ctrl + Mouse scroll" 
- Toggle between matching parenthesis using "Ctrl+]", also hold shift for selection
- Query tabs now have tooltips that show full file path (for non-embedded queries of course)


Bugfixes
============
Small fix for the autocomplete functionality for non-sqlite engines when identifiers need to be quoted. 

Version
1.4.239.1
Created on
8.12.2015. 19:54:58 (UTC)
Md5
27a0b56801d3d9784ede96479934566c
What's new
Summary
========
Big update! I've been working on it for a long time and I'm pretty proud of this one. The focus of this update is analysis of your SQL commands as-you-type. Currently it's for SQLite only (i.e. for Live mode), other engines will still not have this functionality available for now (the SQLite dialect was easiest to start with). As all versions so far, also includes some minor changes and quite a few bugfixes.


Live mode improvements
====================
So as mentioned, this area is the focus of the update. ThingieQuery now has it's own SQL parser (for SQLite only so far). This enables it to understand what you are typing as you type it. The following is a list of new features based on the new parser:
- Detects undefined symbols
- Detects ambiguous symbols and displays possible options
- Detects some illegal situations in code (a sub-select that needs to return only one value having multiple columns specified)
- Tooltips for symbols 
- Tooltips for errors
- Tooltips for star symbols (*) display all columns included (works properly with nested subqueries and cte-s)
- Highlighting all symbols that reference same object as the symbol with the caret
- Autocomplete is context sensitive and knows when to offer tables, views, columns etc. and which ones are legal
- Autocomplete offers keywords (context sensitive!)
- Autocomplete now supports autocompleting columns from dynamic objects: aliases, subqueries, common table expressions (scope sensitive!)
- Parenthesis highlighting

Upcoming features (not yet included)
- Expanding * columns
- Renaming symbols
- Auto formatting SQL


Editor improvements
================
- current line (with the caret) is slightly highlighted
- drag&drop moves the caret as you drag so you can drop anywhere in the query instead of only at the current position
- drag&drop from the object explorer escapes names based on the engine used


Other improvements
================
- No longer removes strange characters from column names when importing them to the db, rather column names are just escaped (and only if needed) based on the rules for the database active engine.


Bugfixes
=======
- @directives are no longer underlined as syntax errors
- recreating a table now works properly
- SQLServer now displays # sign in front of imported tables (was omitted by mistake in one of the previous versions)
- Fixed issue that caused crashing when multiple workbooks were open
- Fixed serious issue with Live mode where it was caching old data, subsequent inserts were getting messed up.
- Fixed the has-changes indicator for file queries (the star was showing even after saving the file)

Version
1.3.238.1
Created on
6.10.2015. 21:35:17 (UTC)
Md5
8467aa59f9cc95e4a976757a8e740f71
What's new
New features for "Live" and "SQLite" engines:
- syntax error highlighting (red squiggly lines, hooray)
- the additional (.NET) functions and their parameters are visible in object explorer and appear in auto complete making them easier to discover and use 

Version
1.3.237.1
Created on
4.10.2015. 11:18:08 (UTC)
Md5
a3312513e617efd4313679181bfecfb1
What's new
...

Version
1.3.236.1
Created on
27.9.2015. 20:23:10 (UTC)
Md5
a1f01c78776dbb105b7ad07bb82091c8
What's new
- Overhaul of the VBA API (soon to be documented in the guide: http://thingiequery.com/Home/Guide)
- Fixed local format when writing dates

Version
1.3.235.1
Created on
27.9.2015. 10:23:53 (UTC)
Md5
aa966a48fd2242533d78615f7510cfbd
What's new
Major feature added: Connecting to MySQL databases

Version
1.3.234.1
Created on
20.9.2015. 19:47:57 (UTC)
Md5
e22c04e4e4424e0a7068b018ceda4ee6
What's new
Major feature added: Connecting to Access databases

Version
1.3.233.1
Created on
16.9.2015. 20:46:26 (UTC)
Md5
a6bc92422d7182f9a9d3a2380fe1f737
What's new
- !!! Fixed a blocking bug for office2010 and Office2007 !!!
- Improvement in connect time
- Tiny bugfixes
- Added Ldis func (Levenshtein distance) for fuzzy comparation of strings (usable in Live mode)

Version
1.3.232.1
Created on
12.9.2015. 18:22:37 (UTC)
Md5
ef0deb30d71a2a849bdaa75a5b012ace
What's new
Bugfixes:
- Updating the contents of a table that has a filter no longer fails, the filters are cleared before updating data. (they are not reapplied after, this is a to-do)
- Fixed some minor issues

Some info about the new "Embeded query automation" feature:
- The embedded queries can be viewed in one of the panes of the ThingieQuery user interface
- You can make a new embedded query by pressing the plus icon
- The embedded query can contain @-directives for writing results to the workbook
- Once you are happy with the query you can click the little robot icon and specify what events will trigger the query to execute (currently only Workbook.Loaded and sometable.Changed events can be used), you also need to specify the database engine that will be used to execute the query
- You can associate queries with a table by using a naming convention: if you have a table in excel called "mytable" and you have an embedded query called "mytable:something" in that workbook, when you right click the table in excel you will see the query in the context menu and will be able to run it from there without having to connect with thingiequery explicitly. You can associate any number of queries with an Excel table just by making sure the embedded queries names start with "thetablename:". 
- If you write the results of a query into a new table in excel, the table writer will also automatically create an embedded query for refreshing the table (unless you tell it not to). If you name the table "mytable", the embedded query will be named "mytable:Refresh" 
- The queries will run whenever triggered but will not prevent user interaction while they are executing (they are always executed in the background)

Version
1.3.231.1
Created on
10.9.2015. 21:08:35 (UTC)
Md5
4bedeb84ab76ba00af8d1c842ba6ae8f
What's new
Test release with automation options for embedded queries (kind of a big feature), a bunch of bug fixes and miscellaneous smaller improvements. Might still have an issue or two, but overall should be stable and work nicely.

Version
1.2.230.1
Created on
24.6.2015. 15:28:16 (UTC)
Md5
a34ebd082c587669836b97468c7ab3d3
What's new
Major upgrade: 
The user interface is completely redesigned to be dock-able and to be able to open multiple files

Version
1.1.229.1
Created on
31.5.2015. 16:20:17 (UTC)
Md5
d0da58f82d35f6e560d792bb6c1450a6
What's new
Slight change in the way trial licenses are activated.

Version
1.1.228.1
Created on
28.5.2015. 8:46:46 (UTC)
Md5
8ad98ddd710e21ebc87597b794a75085
What's new
- Added new functions (type(arg), cellvalue(address)) for the direct mode, fixed some minor issues with a few others. 
- Slight improvements in the VBA automation API
- Sorted out the display issue on the licensing form in cases where windows display item size > 100%. 

Version
1.1.227.1
Created on
22.5.2015. 8:11:27 (UTC)
Md5
759a7f2da57d9a49864fba7e5b89e86a
What's new
New features:
	- New button for opening/closing the ThingieQuery task pane

Bug fixes:
	- Fixed a bug related to cancelling a query 
	- Fixed some logging for some internal SqlServer commands
	- Fixed a licensing issue

Version
1.1.226.1
Created on
16.5.2015. 9:54:16 (UTC)
Md5
f50614a60887eb1a681438ea96c984ae
What's new
Bugfixes:
	- Multiple rapid clicks on “Connect to” no longer confuse the heck out of ThingieQuery
	- Fixed the stall issue when closing Excel 

Licensing:
	- In some cases a unique hardware id could not be obtained which resulted in trial license requests being refused, now fixed by using MAC address when HDD SerialNummber cannot be obtained

Changes:
	- Internal libraries updated to the .NET45 versions (this is just an internal change)

Version
1.1.225.1
Created on
13.5.2015. 16:11:11 (UTC)
Md5
5f629e566e2563037a5053964631bd4f
What's new
This version contains major changes to the way background operations (like executing a SQL command) are implemented with huge improvements in stability, query performance and as always some bugfixes and a few miscellaneous improvements. 

Performance:
	- The load time of the plugin (when starting Excel) is considerably faster
	- Background operations have been re-implemented completely using the .NET 4.5 async libraries, which hugely improves stability (code is much simpler=fewer bugs) uses less resources, and improves performance 

Changes:
	- The message log is now a RichTextBox (instead of a ListBox), you can now select text inside it and copy-paste it.
	- The message log now shows all SQL commands (even the ones ThingieQuery executes itself) as well as the number of affected rows for each command
	- Autocomplete (for "@ directives") now automatically adds an "=" after selecting a property name

Bug fixes:
	- Fixed a ton of bugs (maybe not a ton, but quite a few)

Installer:
	- This version requires .NET 4.5 (instead of .NET4.0), so the installer has been changed to automatically install it in case it's not present

Version
1.0.224.1
Created on
6.5.2015. 14:52:02 (UTC)
Md5
d141bb735b8b3c46390fdf78bc9009f9
What's new
Bug fixes:
	- In direct mode when deleting a table, the object explorer sync would crash. This is a new bug introduced in the previous version, now fixed.
	- Workaround for an issue when displaying results that have column names with special characters (up until now, the column would display blank results)

Version
1.0.223.1
Created on
6.5.2015. 6:42:52 (UTC)
Md5
54d426c60f728f3489e870c636685d7a
What's new
Features:
	- VBA integration #1: ThingieQuery can now be automated from VBA (documentation coming up). You can register a start-up script that will execute when it connects in direct mode, and you can automate running queries regardless of the state of the ThingieQuery UI. 
	- VBA integration #2: ThingieQuery can call VBA functions in the direct mode, e.g. vba('Module1.MyFunction', arg1, arg2, ... , argN). Also, in the direct mode, each table now has a hidden column "__address" which you can use to pass to VBA functions, for instance if you want to color rows based on some SQL criteria.
	- Direct mode: support for user created views and tables in object explorer and autocomplete (creating and dropping is automatically detected and sync’d). 

Changes:
	- updating a table via ThingieQuery no longer automatically selects it (you can change this behavior on the table writer properties)

Bug fixes:
	- Autocomplete duplicates removed
	- Some minor bug fixes

Version
1.0.222.1
Created on
1.5.2015. 11:00:50 (UTC)
Md5
89d05bafb438e30d91342d14d8260b7f
What's new
Bugfixes:
	- ribbon shortcuts were not working on Excel2007 and Excel2010, now fixed
	- fixed two ugly bugs related to the object explorer (one of them would crash excel2007 in some situations)
	- better sync-ing between Excel and ThingieQuery when closing/opening workbooks

Features:
	- user can now cancel loading tables into SQL Server (SqlBulkCopy now checks a stopFlag after each batch of 5000 rows)

Version
1.0.221.1
Created on
29.4.2015. 17:23:48 (UTC)
Md5
d3d0832dcbd74b12e317c9305110cba8
What's new
Features:
	- added support for (SQL Server) views/functions/procedures in the object explorer and autocomplete 

Changes:
	- in the external mode, items in the object explorer are organized by type instead of by schema
	- in the direct mode, tables in the object explorer are organized by workbook instead of by schema

BugFixes:
	- fixed an issue with synchronizing ThingieQuery tables with Excel tables in the direct mode

Version
1.0.220.1
Created on
26.4.2015. 21:03:50 (UTC)
Md5
70dc9fdf96ffbc20666d628bd18c704c
What's new
Overhaul of load/connect functionality: 
- Direct mode is now synchronized with Excel within the selected scope (active sheet, active workbook, all workbooks). Modifying/adding/deleting tables is automatically reflected in the object explorer and autocomplete, no need to reconnect. Even changing data of a table can trigger a schema refresh, if the new data is of a different type.
- Multiple tables with the same name can now be loaded from separate workbooks.

Bugfixes:
- Fixed a bug with decimal columns (manifested in direct mode). 

Version
1.0.219.1
Created on
14.4.2015. 14:29:20 (UTC)
Md5
c0110a24f1a1f0fc1474521120af9b92
What's new
Fixed an issue with licensing (machine ID was not necessarily unique from machine to machine). 

Version
1.0.218.1
Created on
1.4.2015. 15:32:57 (UTC)
Md5
5854fb25ebf3303593c4795a46db99f5
What's new
Connecting to SQL Server now requires less permissions (db_datareader is enough).

Version
1.0.217.1
Created on
27.3.2015. 15:20:49 (UTC)
Md5
9f84bcc4feabaf89f0e26dbcf3f1253d
What's new
Added auto-update functionality.

Version
1.0.216.1
Created on
5.3.2015. 10:30:01 (UTC)
Md5
3500f3353feea3d347fecab9ec8706e9
What's new
This first entry also includes many changes made in previous versions. Since the first release these are roughly the changes:

New features:
	- ThingieQuery can now override Excel shortcuts in the scope of the ThingieQuery window.
	- All columns now have hash indexes in direct mode (not applicable to external connections)
	- A few custom SQLite functions added
Bug fixes:
	- numerous bug fixes related to situations where multiple workbooks are open in Excel2013
	- icons fixed for Excel2007
Licensing:
	- WCF configuration exposed to the user via the config file
	- enabled use of default credentials when going through proxy
Installation:
	- installation is now per-user (licenses are still per machine of course)
	- installer trimmed down
	- no longer requires admin privileges (except if prerequisites missing)
	- works for Excel2007

.
.
.
Here be dragons. Even though previous versions were available, this record was not up at the time.