Hello everybody In a before insert or update trigger I have the following cases:
*Case 1:* IF (NEW.MVC_TIPMOV = 'SVT' AND INSERTING AND NEW.MVC_NRODOC = '1') THEN BEGIN END *Case 2:* IF (NEW.MVC_TIPMOV = 'SVT' AND INSERTING OR UPDATING AND NEW.MVC_NRODOC = '1') THEN BEGIN END *Case 3:* IF (NEW.MVC_TIPMOV = 'SVT' AND (INSERTING OR (UPDATING AND NEW.MVC_NRODOC = '1'))) THEN BEGIN END No problem with Case 1 and with Case 2, they both compiles well. However Case 3 doesn't compile. Why? Why it is not possible to use parentesis? Firebird 2.5.2, SuperServer Greetings. Walter.