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:

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMEEVENT_NAMEHANDLER_SCHEMAHANDLER_NAMEHANDLER_TYPEHANDLER_CODETARGET_WORKSHEETMENU_ORDEREDIT_PARAMETERS
 s02view_cashbookChanges02view_cashbookVIEW_Commit
 s02usp_cashbookChanges02view_cashbookVIEW_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.