Hi - In MySQL, I can do CREATE TRIGGER UpdateSaleItemDescription BEFORE INSERT ON SaleItem BEGIN SET NEW.SaleItem_Description='Fish'; END;
and I can't do CREATE TRIGGER UpdateSaleItemDescription AFTER INSERT ON SaleItem BEGIN UPDATE SaleItem SET SaleItem_Description='Fish' WHERE SaleItem_ID=New.SaleItem_ID; END; because that's trying to update the table that's already being updated, and MySQL won't let you. SQLite appears to be the opposite: I can't do the first example in SQLite, but I can do the second. Is it correct that I can't do the first, or am I misreading the syntax? Best wishes, Hamish -- View this message in context: http://old.nabble.com/SET-NEW.FieldName-in-trigger-tp33413040p33413040.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
