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)
I'm not Sure what isolation level I'm using. Whatever is default I expect. I'm
using an ORM and python interface. I will need to dig into this a little
deeper. However, my transaction do not overlap, so I don't expect the isolation
level to matter.
Regarding using the embedded interface from
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
