Release Notes for Database plugin
1.16.7.0
23 Jun 2022
- Fix bug: Database ExecuteSQL Result Editor does not update column types
1.16.6.0
13 Apr 2022
- Fix bug: Do not save design-time connection string in Database plugin
- Fix bug: ExecuteSQL result type types not always mapped
1.16.4.0
29 Mar 2022
- Fix bug: Object reference error in ExecuteStoredProcedure result fields editor
1.16.3.0
26 Nov 2021
- Fix bug: Undo action in ExecuteSQL function not reverting all changes
1.16.2.0
22 Sep 2021
- Update third-party libraries
- Remove Sort property from MongoDBMapReduce function
1.16.1.0
1 Sep 2021
- Update third-party libraries
- Fix bug: Error when trying to use a MySql stored procedure with a LONGTEXT parameter in ExecuteStoredProcedure function
1.16.0.0
17 Jun 2021
- Change batch size property to accept a dynamic value on DbBulkCopy function
- Update third-party libraries
- Fix bug: Sequence error thrown when connecting to a Mongo cluster
- Fix bug: Dragging or double-clicking variable on icon not working in SQL editor
1.15.4.0
16 Jul 2020
- Fix bug: SQL editor displays incorrect column names for SQLite connection in ExecuteSQL function
1.15.2.0
11 Mar 2020
- Fix bug: Multi-line expressions in SQL editor not working correctly
1.15.1.0
17 Jan 2020
- Update third-party libraries
1.15.0.0
11 Dec 2019
- Add Timeout property to ExecuteStoredProcedure function
- Persist size and position of Result type editor in ExecuteSQL function
- Wrap ExecuteSQL result type query in transaction to prevent database modification
- Fix bug: Result type editor allowed invalid scenarios when mapping results to a custom type
1.14.1.0
6 Sep 2019
- Fix bug: DbBulkCopy throws runtime exception when table name contains spaces or is reserved word
1.14.0.0
8 Mar 2019
- Move focus to first value item in connection string editor
- Display null values in SQL test editor
- Display datetime values in current culture in SQL test editor
- Fix bug: OLE DB wizard does not populate connection string editor correctly
- Fix bug: DbBulkcopy throws unhandled exception when saving invalid table name
- Fix bug: Connection string editor throws away user info for SQL Server connections
- Fix bug: Connection string property cannot be set to empty string
- Fix bug: MongoDB functions cannot resolve connection string from setting value at design time
- Fix bug: ExecuteSQL function does not update result type correctly when column type changes
- Fix bug: MongoDBRead/Write does not compile when hidden properties contains invalid references
1.13.752.0
13 Sep 2018
- Change editor styles to conform with Linx
- Add validation on Connection string property
- Improve retrieval speed of available procedures in stored procedure editor
- Add items in ExecuteSQL function SQL editor by double-clicking on them
- Update Linx plugin
- Update third-party libraries
- Fix bug: ExecuteSQL function does not support all SQL Server types
- Fix bug: Find references did not find references in ExecuteSQL function
- Fix bug: ExecuteSQL function does not return schema for multi-statement table-valued function
1.12.100.660
29 Dec 2017
- Fix object reference error when adding output field.
1.11.98.655
23 Oct 2017
- Fix SqlBulkCopy does not show Loader.Write properties.
- Add Sql script generation to SqlEditor.
- Update Linx Plugin library.
- Update Oracle database client.
- Update UI styles.
- Improve SqlEditor drop zone.
- Improve MongoDb editors.
- Fix ExecuteSQL field mapping error.
- Fix ExecuteSQL output field creation when using temp table.
- Fix ODBC insert query adds record when connectionstring/query changes.
- Fix ExecuteSql Connection Editor overwrites properties.
- Fix Cannot assign String to ExecuteSQL.ConnectionString.
1.10.76.559
23 Jun 2017
- Fix DBBulkCopy fails silently on exception.
- Update Linx plugin
- SqlEditor persists last size and layout.
- Allow MongoDbRead and MongoDbMapReduce to return string output.
- Fix ExecuteSql insert null fails.
- Improve SqlEditor UI.
- Persist size and position of custom editors between sessions.
- Fix ExecuteStoredProcedure error when returning binary.
- Fix duplicate parameters in connection string error.
- Fix SqlBulkCopy shows no properties when setting Write property.
1.9.66.521
12 Apr 2017
- Fix ExecuteSql properties load when hidden.
- Fix DBBulkCopy fails silently on exception.
1.8.63.514
20 Jan 2017
- MongoDbRead: Replace Loop results with Return options.
- MongoDbMapReduce: Replace Loop results with Return options.
- Update Linx plugin.
1.7.60.504
9 Sep 2016
- SQLEditor: Fix Fetch button border.
- Update NuGet packages.
- Update Linx plugin.
- Update UI styles.
- MongoDbRead: Split Find and Aggregate operations.
- Add MongoDBMapReduce function.
- MongoDBRead: Change editors.
- MongoDBMapReduce: Add editors.
- Update plugin utilities.
1.6.45.451
3 Jun 2016
- Fix validation error for multiple missing custom type fields.
- Fix parameter name clash with properties.
1.5.42.443
29 Apr 2016
- Update Linx Plugin.
- Add variable panel to SQLEditor.
- Fix duplicate variable in ODBC sql causes error.
1.4.35.419
11 Feb 2016
- Update database drivers.
- Improve tab order on editors.
- Fix Insert Expression on Mongo Editors.
1.3.31.407
3 Feb 2016
- Fix DbBulkCopy output not changed when table is changed.
- Update Linx Plugin.
- Changed tab order on controls.
1.3.25.387
7 Dec 2015
- Display new connection string editor when cannot parse existing connection string successfully.
- Fix "SET FMTONLY ON" scenario for stored procedures that contain dynamic SQL (replace default parameter values with null).
1.3.22.381
26 Oct 2015
- Fix reader with blank column names cause index out of bounds exception.
1.3.20.377
20 Oct 2015
- Update Linx plugin
- Fix object reference bug for invalid number of result sets.
- Fix duplicate parameter bug.
- Add logging.
- Resolve dynamic transaction connectionstring when queried as reference.
- DbBulkCopy: Add Timeout property. Default is 30 seconds.
- Fix ExecuteSql and StoredProcedure forces use of Oracle even if OLEDB is selected.
- Fix StoredProcedure shows user defined functions.
- Add CustomType option to ExecuteSQL Output Editor.
- ExecuteSQL ResultTypeEditor: Make drag-drop consistent with ExecuteStoredProcedure grids.
- ExecuteSQL ResultTypeEditor: Name column now defaults to value in ColumnName.
- Fix ExecuteSQL: CustomType does not save.
- Fix ExecuteSQL ResultTypeEditor: Validation.
- Fix ExecuteSQL: Validation on CustomType of result type.
- ExecuteStoredProcedure: Add validation on CustomTypes of result sets.
- ExecuteSQL and ExecuteStoredProcedure: Replaced result set custom type selector with TypeReferenceEditor.
- ExecuteSQL ResultTypeEditor: Use TypeReferenceEditor for field types.
- Add CustomType option to ExecuteSQL Output Editor
- Update ExecuteSQL function output from Int32 to Int64
1.3.3.327
11 Aug 2015
- Update MongoDb drivers.
- ExecuteSQL to use Transaction.
- BeginTransaction: Test all isolation levels.
- BeginTransaction: Added icon for Transaction object.
- ExecuteStoredProcedure to use Transaction.
- Update Linx plugin.
- Fix bug: Database connection wizard stays open after update.
1.2.3.303
19 Jun 2015
- ConnectionEditor: Add Wizard to OLEDB type.
- Update Linx Plugin API.
- ExecuteSQL: Replace ConnectionString with ConnectionType and ConnectionString to give finer grained control over which drivers to use.
- Sort output tables.
- Fix bug: String as enumerable conversion error.
- ExecuteSQL (OLEDB): Fix locale settings related conversion issue with floating point valued sql parameters.
- Add BeginTransaction Function.
1.1.48.273
15 May 2015
- Add DbBulkCopy function
- Update Linx plugin
- ExecuteStoredProcedure: Detect connection type when changing connection string
- ExecuteStoredProcedure: Fixed crash when setting connection string to a variable
- UI changes
1.0.37.241
25 Feb 2015
- Add ExecuteSQL function
- Add ExecuteStoredProcedure function
- Add MongoDBRead function
- Add MongoDBWrite function