Change Handlers with DBGate
DBGate reads the handler configuration tables and views.
It supports features described in the following topics:
- Change Handlers Using Stored Procedures
- Change Handlers Using SQL
- Change Handlers Using Tables
- Change Handlers Using Views
DBGate creates API endpoints for each change handler and publishes change handlers in the metadata CHANGE_HANDLERS properties of objects and columns.
You can try online samples:
- https://dbgate.savetodb.com/api/mssql-023/en-us/s02/usp_cashbook3/$metadata
- https://dbgate.savetodb.com/api/mssql-023/en-us/s02/view_cashbook3/$metadata
The built-in JavaScript client and SaveToDB 8+ read the DBGate metadata and execute POST commands on every cell change.