Change Handlers Using Views

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

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

Here is a sample configuration in 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, which must exist in the selected data.

Such handlers update only existing rows.

To mark changed rows as saved, use the _Commit word in the TARGET_WORKSHEET column.

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