QueryStorm Releases
Released: Feb 11, 2022
Updates in 2.6.x
2.6.8092.14763
Updated Feb 26, 2022
Features
- Added the ability to recreate output tables when running SQL scripts.
Fixes
- Fixed bugs (IDE):
- Double-clicking an error in a file which was not previously opened would only open the file, not go to the offending line.
- C# indentation strategy was not working well with lambdas so reverted to a simpler indentation strategy.
- IDataContext could not be resolved from C# scripts.
- Importing a workbook project into the workbook was failing to update files...
Released: Aug 31, 2021
Updates in 2.5.x
2.5.7923.20438
Updated Sep 10, 2021
Features
- Added support for configuring SSL in Postgres connection strings.
- When using [BindTable] the binder can now detect the table name based on the property type, if it is a table wrapper class (but not if it is Tabular).
- SQL preprocessor now forbids illegal combinations of declarations (e.g. can only use {@tbl} in a handler but not in a function or query) and gives better error information.
- Added a "netstandard.dll" reference into the default config...
Released: Aug 10, 2021
Updates in 2.4.x
Features
- Trusted documents - This version prompts the user to confirm that they trust the workbook before allowing it to run. Once a workbook app is trusted, the user will not be prompted again.
- Context menus - Context menus can now be defined much more easily compared to using the native Microsoft Excel API for context menus (i.e. CommandBars).
- App settings - Apps can now define settings much more easily by creating a class that exposes configuration properties and...
Released: Jun 1, 2021
Updates in 2.3.x
2.3.7824.17314
Updated Jun 3, 2021
Fixes
- Fixed compilation of projects with references to local system DLLs.
- Minor fixes to ribbon class template.
- Fixed publishing packages with native DLLs.
- Prevent creating multiple projects in a workbook, as this scenario is not yet supported.
- Better handling for project load errors.
- Better handling for async function crashes.
- Fixed a focus issue with the undocked QueryStorm window where all text input would go to Excel.
- Fix for project deletion issues (add...
Released: Jan 18, 2021
Updates in 2.2.x
2.2.7734.36528
Updated Mar 5, 2021
Fixes
- Refactoring the app contract: - shortcut service now allows unregistering shortcuts.
- An app's configuration can now supply a handler for the "OK" button in the config dialog
2.2.7732.23346
Updated Mar 3, 2021
Fixes
- Fixed issue with "Configure extensions" dialog (in the runtime) that prevented from changing the selected item in the list.
2.2.7730.34357
Updated Mar 1, 2021
Features
- QueryStorm extensions can now define shortcuts and allow users to configure...
Released: Nov 10, 2018
Updates in 1.13
Features
- Preprocessor now allows resolving to unquoted strings (e.g. column names), by starting the expression inside the curly brackets with # sign e.g.: select {#columnName} from myTable
- (Here columnName is a named range containing the name of the column to resolve. Cell references are also valid (e.g. {#A1} or {#Sheet1!A1}).)
- C# engine:
- Column names that have illegal C# identifier names are normalized and are now accessible as properties (not just via indexer).
- Properties can be decorated...