Hello together, I tried hard to reimplement some db triggers in sapdb. One simple problem is that a column of type timestamp should be filled with the value of the system watch with the value of the execution time. I need something like
CREATE TRIGGER TR_MYTAB FOR TAB_MYTAB BEFORE INSERT, UPDATE EXECUTE (SET NEW.DATEOFUPDATE=CURDATE();) Two things won't work. There are no BEFORE-triggers in sapdb and CURDATE(); is of type DATE and not of type TIMESTAMP. Is there a way out. Other similar purposes are information columns which user or process changed the record lately. Guido _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
