docs.intersystems.com
Home / Class Definition Reference / Trigger Keywords / OldTable

Class Definition Reference
OldTable
Previous section           Next section
InterSystems: The power behind what matters   
Search:  


Specifies the name of the transition table that stores the old values of the row or statement affected by the event.
Usage
To specify the name of the transition table that stores the old values, use the following syntax:
Trigger name [ Event = sqlevent, OldTable = oldtable, NewTable = newtable ] {    //implementation }
Where oldtable is the name of an SQL table in this namespace.
Details
Each trigger has access to the old and new values of the row or statement affected by the event, by means of transition tables (specified by the OldTable and NewTable keywords).
Default
The default is an empty string.
See Also


Previous section           Next section
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-10 14:45:57