Change Handlers Using Tables

Change Handlers Using Tables

You can set the table as a change handler for any object or for the table itself.

In this case, SaveToDB products will save changes to the target table 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
 s02cashbookChanges02cashbookTABLE
 s02view_cashbookChanges02cashbookTABLE_Commit
 s02usp_cashbookChanges02cashbookTABLE_Commit

Target tables must have primary key or identity columns, and the columns 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.