Triggers are methods attached to a table whose execution depends on database events; when a record is being created, modified or deleted. Because of this, they can be used for a variety of reasons like data control, relational integrity, encrypting and decrypting data and so on. These actions can be done outside triggers but the developer needs to take into consideration that records can be created, modified and deleted not only from 4D forms but also from web connections, ODBC connections, SQL Pass-through and so on. In cases like these, triggers can be used to track for any record changes. This Technical Note describes the trigger mechanism in 4D.


Download Complete Tech Note and example: Windows | Mac