KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Triggers in 4D v11 SQL
PRODUCT: 4D | VERSION: 11.4 | PLATFORM: Mac & Win
Published On: August 20, 2009
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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