SaveToDB Framework History
Version 9.9, July 20, 2020
- The xls.xl_actions_generate_handlers procedure generates typed parameters for cell number and datetime values.
- The xls.handlers.EVENT_NAME column includes new values available in SaveToDB 9.9: DefaultValue and JsonForm.
- The SaveToDB Developer Framework installation script has a bug related to dependency on xls.view_framework_objects.
- The Actions menu of the SaveToDB Developer Framework does not show the @MySqlStyle parameter.
- The xls.usp_database_permissions procedure of the SaveToDB Administrator Framework does not show the CREATE PROCEDURE permission.
Version 9.8, June 23, 2020
- The xls.handlers.EVENT_NAME column includes new values available in SaveToDB 9.8:
DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, DataTypeTime,
DoNotSort, and DoNotTranslate.
- The SaveToDB Developer Framework includes a new view, xls.view_framework_objects.
The view uses the same code as the SaveToDB Add-In, DBEdit, ODataDB, and DBGate to detect configuration objects.
- The xls.view_all_translations view excludes the framework objects.
- The xls.usp_translations procedure has a new parameter, @is_complete, to filter completed and incompleted translations.
- The xls.xl_actions_generate_procedures procedure generates typed parameters for cell number and datetime values.
- The SaveToDB Developer Framework installation script has a bug related to the GO command.
Version 9.6, February 27, 2020
- The xls.handlers table includes a new Format EVENT_NAME value.
Version 9.5, January 17, 2020
The copyright changed to Gartle LLC, former Gartle Technology Corporation.
Version 9.4, October 17, 2019
- SaveToDB SDK uses a new installer based on a new dbsetup.exe tool instead of gsqlcmd.exe.
The new free tool is designed for installing, uninstalling, and updating databases.
- SaveToDB Frameworks use a single script to update any previous version starting 9.0 to the latest one.
- The EVENT_NAME column of the xls.handlers table includes new values: BitColumn, Information, and RegEx.
- Updated SaveToDB Administrator Framework for SQL Server
You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to manage permissions.
- Updated SaveToDB Developer Framework 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.
- SaveToDB Developer Framework has fixed issues with generated SQL code output with the MSOLEDBSQL provider.
Version 9.3, September 17, 2019
- The EVENT_NAME column of the xls.handlers table includes new values: AddHyperlinks and License.
- The xls.queries view excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.
Version 9.1a, November 7, 2018
- The HANDLER_TYPE column of the xls.handlers table includes new values: SHOWSHEETS, HIDESHEETS, SELECTSHEET
- The xls.queries view excludes xls.objects objects with the xl_ prefix.
You may use this prefix for defined SQL code objects used in the xls.handlers table as handlers.
Version 9.1, July 17, 2019
- The xls.handlers table includes a new DynamicColumns EVENT_NAME value.
- The SaveToDB Framework for Oracle supports Oracle Database 18c and includes the improved XLS.QUERIES view.
- SaveToDB Developer Framework allows generating code in MySQL style like column_name instead of ColumnName.
- Updated SaveToDB Administrator Framework.
Version 9.0a, September 10, 2018
- The xls.xl_actions_generate_procedures procedure allows generating ready-to-use objects:
- SELECT views and procedures, from tables and views;
- procedures for INSERT, UPDATE, and DELETE operations;
- Change event handler procedures.
- The xls.xl_actions_generate_handlers procedure allows generating template procedures of event handlers:
- The Actions menu includes menu items for generating objects described above.
To disable this feature, set the DENY SELECT permission on the xls.view_developer_handlers view.
- The xls.xl_actions_generate_constraints procedure allows generating primary, unique, and foreign keys.
Use the xls.view_primary_keys, xls.view_unique_keys, and xls.view_foreign_keys views to check and generate keys using the context menu.
- The xls.usp_translations procedure allows translating object names, fields, and parameters.
- The xls.view_all_translations view allows translating names into several languages at once.
- The xls.usp_role_members procedure allows managing user roles.
- The xls.xl_export_settings and related import procedures allow exporting and importing settings.
- The xls_formats role includes the permission to save table formats into the xls.formats table.
To add or remove users from a role, use a form based on the xls.usp_role_members procedure.
- The xls.xl_actions_set_role_permissions procedure sets permissions for the framework roles.
- The Application Workbooks wizard includes the new SaveToDB Framework 9 configuration workbook.
- The Actions menu includes updated links to the SaveToDB add-in documentation and SaveToDB Framework objects
Version 9.0, February 5, 2019
- SaveToDB Framework 9.0 and 9.1 of 2018 renamed to 9.0a and 9.1a.
New SaveToDB Framework 9.0 for SQL Server has the same version as frameworks for other platforms.
SaveToDB Framework 9.1a split into three parts:
- SaveToDB Framework
- SaveToDB Developer Framework
- SaveToDB Administrator Framework
SaveToDB Framework 9.2 is a complete copy of SaveToDB Framework 8.19.
It is a run-time part available on all supported database platforms.
SaveToDB Developer Framework includes objects to support application development. It contains most of the objects added in SaveToDB Framework 9.0.
SaveToDB Administrator Framework contains objects to manage database permissions.
The updated SaveToDB Application Installer 9.0 allows choosing frameworks to install and uninstall.
So, you may install all frameworks into a development database and only a framework run-time into a production database.
- SaveToDB SDK contains a universal SaveToDB Application Installer 9.0.
The installer allows installing, uninstalling, and checking any application and framework using source codes for any supported database platform.
The installer suggests step-by-step confirmation to install or remove the desired components.
It supports the following frameworks:
- SaveToDB Frameworks 7, 8, 9
- SaveToDB Developer Framework
- SaveToDB Administrator Framework
- Change Tracking Framework
- Database Help Framework
The installer requires the free gsqlcmd 5.0 command-line utility.
Of course, you may install and uninstall any application or framework with source codes using your favorite tool.
- SaveToDB Administrator Framework includes new procedures for managing permissions:
The framework includes a new role, xls_admins, that allows executing these procedures and the xls.usp_role_members procedure.
Adding users to this role is safe. The procedures are executed in the user context. So, users can execute GRANT, DENY, and REVOKE if they have permissions only.
- The xls.workbooks table has an additional TABLE_SCHEMA column.
This column allows filtering and exporting the desired schemas.
The column must be in the last position. Otherwise, SaveToDB 8.18 and prior cannot detect this configuration table.
- The validation list of xls.handlers.EVENT_NAME field includes new types: AddStateColumn, KeepFormulas, DoNotKeepFormulas, UpdateEntireRow, UpdateChangedCellsOnly
- xls.workbooks contains new workbook definitions for the Application Workbooks wizard.
- SaveToDB Framework 8 and 9 have the following file names:
SaveToDB Framework 7 has the file names with the -en suffix:
In this article