Write trigger

Write triggers make changes to the data of a database while the data sheet is being saved. It is possible, for example, to save the price history of an item and to whom it was sold.

The SQL string that will update the values will be inserted in the left-hand column. All fields enclosed in square brackets will be replaced with the actual values of the data sheet at the time of saving.

As with the read triggers, it is possible to set very specific conditions so as to activate the trigger only in certain situations.