apache > db
Apache DB Project
 
Font size:      

Accessing Before and After Rows

Accessing Before and After Rows

Many trigger actions need to access the values of the rows being changed. Such trigger actions need to know one or both of the following:

  • the "before" values of the rows being changed (their values before the database event that caused the trigger to fire)
  • the "after" values of the rows being changed (the values to which the database event is setting them)

Derby provides transition variables and transition tables for a trigger action to access these values. See"Referencing Old and New Values: The Referencing Clause" in the Derby Reference Manual.


Previous Page
Next Page
Table of Contents
Index