Saving Without Transactions
By default, all changes are saved within a single transaction.
You can disable transaction mode by using the SaveWithoutTransaction 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 | SaveWithoutTransaction | ATTRIBUTE |
This approach is particularly useful when you need to manage transactions within procedures for saving changes.