BlackbirdSql DDEX 2.0 Provider & SqlEditor 14.5.1.0 Release

[BlackbirdSQL]

Minor enhancements and code cleanup.

New / Enhancements

• Enabled the IDE SplitNext (F6) and SpitPrev (Shift-F6) global commands with AutoScroll. Grids in multiple resultset queries will automatically scroll into view when they receive focus.
• Moved the initial statement terminator (batch separator) user option to SqlEditor > Query Execution > General so that it now appears in the Live Settings of a query. Setting the option within a query affects multi-statement script parsing only.
• Enabled the Commit and Rollback SQL statements in SqlEditor scripts. These statements were previously disabled.
• Code cleanup: Converted calls to the RdtManager ShowWindowFrame() and InvalidateToolbar() methods to direct calls instead of using an event driven mechanism. This includes calls to the Async versions of these methods.
• Code cleanup: Converted all references to the this object in extension members to the name @this.
• Code cleanup: Converted all references to string.Empty to it's functionally equivalent constant "".
• Code cleanup: Moved all native db script parsing of server explorer nodes into a separate IBsNativeDbServerExplorerService service. This is to unclutter the IBsNativeDatabaseEngine service. Also moved the handling of native db error types into the IBsNativeDbException service.
• Code cleanup: Dropped the IBsNativeDbCommand, IBsNativeDbConnection and IBsNativeDbConnectionWrapper services, as equivalent functionality was already available in the remaining native database services.

Fixes

• Fixed issues with the IBsDbExceptionService. Database exceptions were themselves throwing exceptions when the exception were of type IscException. This caused error information loss when a critical Firebird connection error was displayed in the Advanced Message Box detailed information popup. Isc exceptions are typically raised when when a connection fails due to a broken network connection or server shutdown. Also configured the service to recognize an FbException with error code isc_net_write_err as a critical error and not an SQL error.
• Removed second attempt to prevent a disconnect of connections that have been idle for 90+ minutes and have active transactions. Executing a mutating low-overhead SELECT statement on the database every 25 minutes fails to prevent the connection shutdown. The shutdown can be prevented by giving the connection a large ConnectionLifetime. The property has an upper limit of int.MaxValue seconds.

Full Changelog: v14.5.0.3...v14.5.1.0

---

This discussion was created from the release BlackbirdSql DDEX 2.0 Provider & SqlEditor 14.5.1.0 Release.