Edition Comparison

Edition Comparison

FeaturePersonalStandardEnterprise
Loading data
Saving data
Saving data using VBA
Wizards
Interface features
Configured features except for cell change event handlers
Cell change event handlersx
Outlook Integration
Commercial usex

Here is a sample of the cell change handler:

CREATE PROCEDURE [xls17].[usp_sales_change]
    @column_name nvarchar(255) = NULL
    , @cell_value nvarchar(255) = NULL
    , @cell_number_value int = NULL
    , @id int = NULL
AS
BEGIN

SET NOCOUNT ON

IF @column_name = 'licensee'
    BEGIN
    UPDATE dbo17.sales SET licensee = @cell_value WHERE id = @id
    RETURN
    END

IF @column_name = 'product_id'
    BEGIN
    UPDATE dbo17.sales SET product_id = @cell_number_value WHERE id = @id
    RETURN
    END

END

The add-in calls such handlers on every cell change.

The cell change handlers can use the predefined parameters like @column_name, @cell_value, or @cell_number_value, and column values using parameters with the same name, like @id.

The cell change handlers can update underlying tables or raise exceptions to prevent cell changes.

Trial Version Limitations

You can use SaveToDB without any limit during a 30-day trial period.

You have to activate the trial.

When the trial period has expired, the SaveToDB add-in stops working, and you have the following options:

  1. To purchase a license and register the SaveToDB Personal, Standard, or Enterprise edition.
  2. To purchase a subscription and register the SaveToDB Personal, Standard, or Enterprise edition.
  3. To stop the use and remove SaveToDB from a computer.

See also

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.