new, old

[nate100]

I am trying to figure out what the following means:

on write of so_mstr new new_so old old_so do:

Does new and old create these alias tables? If anybody can let me know how it works. Thank you.

 

[Casper]

From online help:

database-object [ referencing-phrase ]

• The name of a database table or field to which the event is applied. If you specify a database-object, the event specified must be a database event. You cannot specify a metaschema table or field (a table or field named with an initial underscore) as the database-object.
  The referencing-phrase is valid only for WRITE and ASSIGN triggers. For WRITE triggers you can specify a name for the record before the WRITE operation and a name for the record after the WRITE operation. This allows you to reference both versions of the record within the trigger. This is the syntax for WRITE trigger:
  
  
  NEW [ BUFFER ] new-record OLD [ BUFFER ] old-record​
  
  
  For an ASSIGN trigger, you can specify a name for the old field value. This is the syntax:
  
  
  OLD [ VALUE ] old-field-name​

HTH,

Casper