DBEdit Change History

DBEdit Change History

Version 1.8, July 31, 2020

Bug fixes:

  • DBEdit shows 'File not found' on opening files and online samples.

Version 1.7, July 20, 2020

New features:

  • DBEdit uses Excel table formats saved from the SaveToDB add-in to set column visibility, alignment, and number formats in the first connection.
  • DBEdit supports the DefaultValue handler that allows setting default values of parameters.
  • DBEdit hides database objects marked with the JsonForm handler from the connection wizard.

Improvements:

  • DBEdit keeps ribbon parameter values with the same name but changed ids.
    For example, the Budget item can have different ids for different companies.
    When a user changes the company_id, DBEdit keeps the Budget item as a parameter.

Bug fixes:

  • DBEdit rarely shows NullReferenceException on opening a workbook.
  • DBEdit rarely crashes on database change in the connection wizard.

Version 1.6, June 30, 2020

New features:

  • The DoNotSort handler allows disabling the translation for the specified column or the entire table.
  • The DoNotTranslate handler allows disabling the translation for the specified column or the entire table.
  • The following handlers allow specifying data types of columns and parameters on unknown types:
    DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
    DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, and DataTypeTime.
    Use these handlers, for example, to specify data types of SQL code parameters or stored procedure columns.

Improvements:

  • German translation added.
  • Improved performance of loading metadata.
  • DBEdit shows a local database file name when opening it.

Bug fixes:

  • DBEdit does not allow changing a database.
  • Conditional formatting does not work with byte, Int16, and Int32 columns.
  • DBEdit cannot connect to SQLite using the ODBC driver.
  • The registration wizard rarely causes an exception.

Version 1.5, May 5, 2020

New features:

  • DBEdit allows loading and refreshing online samples using the File menu.

Improvements:

  • DBEdit supports new formulas in conditional formats: even, odd, tr:nth-child(even), and tr:nth-child(odd).
  • DBEdit shows TRANSLATED_DESC values as column header balloons.
  • DBEdit completely supports DoNotChange, DoNotSave, DoNotSelect, and ProtectRows handlers.
  • DoNotChange handlers do not disable automatic validation list handlers of the underlying columns.

Bug fixes:

  • DBEdit does not reload validation lists in some cases.

Version 1.4, February 28, 2020

New features:

  • DBEdit allows printing documents.
  • DBEdit supports conditional formatting using format handlers.
  • Users can select the default font and highlight color in DBEdit Options.
  • Users can use View, Show Gridlines to show or hide gridlines.
  • The selected area looks like in Microsoft Excel.

Improvements:

  • Improved registration wizard
  • Improved activation in a virtual environment
  • Updated Snowflake .NET Provider
  • Updated SaveToDB Framework 9.6
  • DBEdit restores column alignment on workbook opening.
  • DBEdit keeps focus in tables on mouse clicks on tabs.
  • Improved CheckBox parameters
  • Improved detection of JOIN relations in views and stored procedures

Bug fixes:

  • Alt-Enter inserts line breaks in number columns.
  • Validation lists with id and code columns do not show values.
  • DBEdit can highlight empty cells like non-nullable in nullable columns.
  • DBEdit does not show timeout errors when loading a database model.

Version 1.3, January 17, 2020

Gartle Technology Corporation changed its name to Gartle LLC.

Changes:

  • Updated EULA
  • Updated About dialog box
  • Updated samples
  • Updated SaveToDB SDK
  • Updated dbsetup tool
  • Updated grx.exe tool
  • Updated registration wizard

Version 1.2, October 21, 2019

New features:

  • A free version of DBEdit has no limits with the following frameworks:
    - SaveToDB Administrator Framework 9.4 for SQL Server
    - SaveToDB Developer Framework 9.4 for SQL Server
    - Database Help Framework 2.0 for SQL Server
    - Change Tracking Framework 3.0 for SQL Server
    You can install these frameworks using source codes from the SaveToDB SDK.
    Each of these frameworks can save a lot of time for administrators, developers, and business users. Now you may use them for free.
  • DBEdit supports all the features of the SaveToDB Planning Application 3.0.
  • A new column-level BitColumn handler allows formatting integer type columns as check-boxes.
    Such columns can have values: 0, 1, and NULL.
  • A new RegEx handler allows processing an output using regular expressions placed in the HANDER_CODE field.
    The Database Help Framework, for example, uses this feature to create hyperlinks in output documentation.
    You can use an embedded grx.exe tool to test expressions.
  • A new Information event name allows adding records for information purposes.
    For example, SaveToDB Frameworks use it to store versions (in the HANDLER_CODE field).
    DBEdit does not process such handlers.
  • A new ATTRIBUTE handler type allows using it instead of the NULL value if other types are not appropriate.
  • DBEdit includes a free DBSetup.exe tool that allows installing, uninstalling, and updating database samples and frameworks.
  • DBEdit includes a free grx.exe tool that allows replacing text using regular expressions.
    You can use it to test expressions for the RegEx handler.
  • DBEdit supports dynamic column translation using stored procedures with parameters.
    For example, a table (view or procedure) contains output columns like Dim1, Dim2, Dim3, String1, String2, Double1, Double2, and so on.
    Depending on the parameter like client_id, columns get names of the dimensions and measures of the specified client.
    To implement this feature, create a procedure with the required parameter (like client_id), which returns two or three columns:
    - an original column name,
    - a translated column name,
    - a visibility flag.
    Then specify the procedure in the HANDLER_SCHEMA and HANDLER_NAME fields of the xls.handlers table with the DynamicColumns EVENT_NAME.
    You can try this feature in Sample 14 - Dynamic Columns.
    This feature is available only with the DBEdit Enterprise edition.
    The visibility flag can have the following values:
    - 1, true, or 'Y' to show the column,
    - 0, false, or 'N' to hide the column,
    - other values or nothing to leave the column visibility as is.

Improvements:

  • DBEdit supports multi-line text in cells.
  • DBEdit supports the copy/paste operations of multi-line cells.
  • The _notransaction value in the TARGET_WORKSHEET field disables transactions of the handler command.
  • The cell editor keeps initial line breaks (\r, \n, or \r\n).
  • The cell editor asks to save changes on exit.
  • DBEdit removes the [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] substring from error messages.
  • The HTML form shows active hyperlinks in a status bar.
  • The HTML form uses the latest available IE web browser control.
  • The grid form shows the current query in a status bar.
  • The grid form supports the context menu handlers.
  • The grid form contains a refresh button in a context menu
  • The grid form saves and restores the last size and position.
  • DBEdit supports handlers of handlers.

Bug fixes:

  • DBEdit shows an exception "Cannot set null."
  • DBEdit formats calculated columns as required with a yellow background.
  • DBEdit formats columns of non-editable views and stored procedures as required with a yellow background.
  • DBEdit does not update columns on underlying query column changes.
  • DBEdit does not translate fields and parameters in the connection wizard.
  • DBEdit does not close context windows on closing a workbook.
  • Data tables lose a cursor position after reconnect.

SaveToDB Samples and Frameworks:

  • SaveToDB SDK uses a new free DBSetup.exe installer instead of the gsqlcmd tool.
    It allows installing examples without additional installations and has improved interactive experience.
    DBSetup.exe is shipped with SaveToDB, DBEdit, and gsqlcmd also.
  • Updated SaveToDB Framework 9.4.
    The EVENT_NAME column of the xls.handlers table includes new values: BitColumn, Information, and RegEx.
    Use BitColumn to format integer type columns as check-boxes.
    Use Information for information records. For example, SaveToDB Framework contains a record with its version.
    Use RegEx to process the output using regular expressions placed in the HANDLER_CODE field.
    The EVENT_NAME column contains values in ascending order.
    The HANDLER_TYPE column of the xls.handlers table contains a new value, ATTRIBUTE.
    You can use this value for declarative handlers like AddHyperlinks, BitColumn, DoNotConvertFormulas, Information, and others that do not have a regular type.
  • SaveToDB Framework 9.4 contains a single file, savetodb-framework-update.sql, used to update SaveToDB Frameworks 9.0 or higher.
    It checks the current features and updates the required.
  • Updated SaveToDB and DBEdit samples
    The samples use a new DBSetup.exe installer.
  • Online samples for SQL Server moved to a new faster server, mssql.savetodb.com.
    We will remove all samples at savetodb.database.windows.net soon.
  • A new sample, Sample 14 - Dynamic Columns, demonstrates the dynamic translation of column names depending on query parameter values.
  • A new sample, Sample 16 - Symbol Lists, shows benefits of application development using DBEdit and Microsoft Excel with the SaveToDB add-in.
  • A new sample, Sample 17 - Budget Request, shows how to create forms like budget requests.
    The database contains several tables of measures like accounts, entities, categories, and times, and a fact table.
    This sample is a redesigned Sample 03 - Budgeting to show core features.
  • Updated SaveToDB Administrator Framework 9.4 for SQL Server
    You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to manage permissions.
  • Updated SaveToDB Developer Framework 9.4 for SQL Server
    You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to generate views and stored procedures to select and edit data.
    The framework has fixed issues with generated SQL code output with the MSOLEDBSQL provider.

Version 1.1, September 17, 2019

New features:

  • A new column-level AddHyperlinks handler used to add hyperlinks to data table column values.
    You can use this handler for regular HTTP/HTTPs links, worksheets, and connected database objects.
    For example, you can create a view with a list of database objects and add the handler to a column with object names.
    In this case, the add-in adds hyperlinks for objects that exist in the workbook, and you can use the view as an index.
    Note, that you can add the Back action to Excel Quick Access Toolbar and navigate back to the index.
  • A new object-level License handler used to allow saving changes in a free version.
    We use this handler in our products like Business Time Tracker or Market.db to allow using the SaveToDB add-in or DBEdit as a database editor.

Improvements:

  • DBEdit highlights cells with NULL values in NOT NULL columns.
  • DBEdit populates default column values in new rows.
  • New Check All and Uncheck All context menu items for bit and boolean columns
  • The three-state mode for nullable bit and boolean columns
  • The auto-commit mode for nullable bit and boolean columns
  • Improved window resize performance
  • ClearContents sets NULLs instead of empty strings in string columns.
  • The default query list excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.
  • DBEdit asks to save changes before changing query properties.
  • DBEdit pastes a single clipboard value into the entire selected range.

Bug fixes:

  • The Save action returns an empty table.
  • Change handlers ignore the _commit option in ClearContents.
  • Shortcuts with Ctrl fires with pressed Shift or Alt.
  • A new table does not set automatic widths.
  • DBEdit shows MySQL bit columns as integer ones.
  • Shift-Insert does not work as Paste.

Samples and Frameworks:

  • Updated SaveToDB Framework 9.3.
    The xls.handlers table includes new AddHyperlinks and License EVENT_NAME values.
    The SaveToDB Framework for SQL Server includes the updated xls.queries view that excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.

Version 1.0, August 5, 2019

DBEdit launched