Compare SaveToDB Editions for Your Database Needs

Starting with SaveToDB 10, the SaveToDB Personal edition is available only through the upgrade warranty and is not available for new purchases.

Here’s a sample of the cell change handler available in the SaveToDB Personal and Enterprise editions only:

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 SaveToDB add-in triggers these handlers on every cell change.

Change handlers can utilize predefined parameters like @column_name, @cell_value, or @cell_number_value, as well as column values using parameters with matching names, such as @id.

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