602SQL Documentation Index  

Calling Triggers when Saving Changes Made in the Grid

Editing records in the grid will cause the appropriate triggers to be executed on the table opened in the grid.

A modification to a record causes the execution of one SQL statement (INSERT when inserting a record or UPDATE when modifying a record). All columns corresponding with the modified entries in the grid and their values are present in this statement.

The set of modified columns that can influence the selection of UPDATE triggers corresponds with all entries modified in the form. If you cannot tell in advance which columns will be edited in the grid, use the UPDATE OF ANY clause in the UPDATE trigger description (details here).