Change Handlers Using Views

You can configure an updatable view as a change handler for any object or for the view itself.

In this setup, the SaveToDB products will immediately save changes to the target view after any cell modifications.

Here's a sample configuration from the xls.handlers table:

ID	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE	TARGET_WORKSHEET	MENU_ORDER	EDIT_PARAMETERS
	s02	view_cashbook		Change	s02	view_cashbook	VIEW		_Commit
	s02	usp_cashbook		Change	s02	view_cashbook	VIEW		_Commit

Target views must have primary key or identity columns that exist in the selected data.

These handlers only update existing rows.

To mark changed rows as saved, include the _Commit keyword in the TARGET_WORKSHEET column.

To save new or deleted rows, users need to click the Save button.