Version 1.2, October 21, 2019
- 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 may install these frameworks using source codes from the SaveToDB SDK.
Each of these frameworks may 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 may 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 may 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 may 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 may 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.
- 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.
- 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 may 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
- A new column-level AddHyperlinks handler used to add hyperlinks to data table column values.
You may use this handler for regular HTTP/HTTPs links, worksheets, and connected database objects.
For example, you may 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 may use the view as an index.
Note, that you may 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.
- 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.
- 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