Razzak
I have been using all six types of trigger for many many years. This discussion under question is the ability to alter the virtual new record in a BEFORE INSERT or BEFORE UPDATE trigger. Say I have a column "MbrRegAudTSHomeInfo" datatype DATETIME. What syntax would I use within the trigger to set the column value to say .#NOW Last time I tried various syntax non worked and I got error messages that the SYS_NEW record is a read only cursor. Jim Bentley, American Celiac Society If you didn't know already, R:BASE supports 6 (six) different triggers as follows: . Before Insert - executes the specified stored procedure before a row is inserted . After Insert - executes the specified stored procedure after a row is inserted . Before Update - executes the specified stored procedure before a row is updated . After Update - executes the specified stored procedure after a row is updated . Before Delete - executes the specified stored procedure before a row is deleted . After Delete - executes the specified stored procedure after a row is deleted The enhanced Data Designer (RBDefine) User Interface in R:BASE eXtreme 9.5 (32/64) will let you automate the entire implementation of Triggers, if you wish. For complete details, steps, and examples ... R:BASE eXtreme 9.5 | Data Designer | Triggers | [Help] ... Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
