Change Handlers Using Views
Special offer: 50% discount ($1440) for ODataDB Enterprise until May 31, 2024

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:


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.