Disabling Saving Data
You can disable saving changes for an entire object or specific columns by 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 is particularly useful when your view or stored procedure becomes editable automatically, which may not be desirable.