13.07.2014 01:31, slu...@iquanta.com wrote:
CREATE TRIGGER ROVMRS_AU FOR ROVMRS AFTER UPDATE
AS
DEC LARE VARIABLE ff SMALLINT;
BEGIN
SELECT FIRING FROM TRIGGER_CONTROL WHERE EVENT = GL_UPDATE INTO :ff;
IF ((OLD.GL = NEW.GL) AND (:ff = 0)) THEN BEGIN
IF (OLD.RCHARGE NEW.RCHARGE)
hey dmitry,
thanx for the advice, i kept digging deeper and i found it in a trigger
under the ROPART, but it wasn't the AFTER UPDATE. it was in the BEFORE
UPDATE where i had a OLD.something assigned and did that because i used
it later in a comparison and i wanted the trigger updated value