Disabling Saving Data
Developers can disable saving changes for the entire object or specific columns using the DoNotSave event type in the xls.handlers table.
For example:
| ID | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | EVENT_NAME | HANDLER_SCHEMA | HANDLER_NAME | HANDLER_TYPE | HANDLER_CODE |
|---|---|---|---|---|---|---|---|---|
| dbo | view_cashbook | DoNotSave | ATTRIBUTE |
This feature can be useful if your view or stored procedure becomes editable automatically but unwanted.