| Subject | Problem with a trigger |
|---|---|
| Author | Walter R. Ojeda Valiente |
| Post date | 2015-02-03T16:53:04Z |
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.