You can change the NEW value in a BEFORE UPDATE in SQLite base

1

This is the code I want to implement but it gives me errors:

1  CREATE TRIGGER tg_b_u_table1
2  BEFORE UPDATE ON table1
3  FOR EACH ROW
4  BEGIN 
5  :NEW.dato_int := 5;
6  END;

Mark line 5 in red

    
asked by Wilfredo Orellana 14.04.2018 в 18:19
source

0 answers