Error in Trigger Sqlite

Question

I’m trying to create this trigger in the SQLite, but I don’t know if it’s possible.

I got a big one Remedios and a Manutenção. I want that when I have an insert in the table Manutenção, it does an update depending on the condition on Case, but is making a mistake in Update.

CREATE TRIGGER TGmovimentacao 
    AFTER INSERT 
    ON manutencao
    for each row 
        BEGIN
            Select Case
                When ( NEW.tpMov = 'S' )
                 then UPDATE Remedio set Remedio.RemedioDose = Remedio.RemedioDose - NEW.qtdDose where Remedio.idRemedio = NEW.idManutencao
            END;
        END;

Answer 1

Your Rigger displays some syntax errors. Here is an alternative

CREATE TRIGGER TGmovimentacao AFTER INSERT ON manutencao
  WHEN NEW.tpMov = 'S'
  BEGIN
     UPDATE Remedio 
        SET Remedio.RemedioDose = Remedio.RemedioDose - NEW.qtdDose 
      WHERE Remedio.idRemedio = NEW.idManutencao
  END;

The instruction FOR EACH ROW is optional since Sqlite only supports FOR EACH ROW triggers and not FOR EACH STATEMENT triggers.

Edit: This version should update the value of Remediodose according to tpMov.

CREATE TRIGGER TGmovimentacao AFTER INSERT ON manutencao
  BEGIN
     UPDATE Remedio 
        SET Remedio.RemedioDose = Remedio.RemedioDose + 
                CASE 
                   WHEN NEW.tpMov = 'S' THEN NEW.qtdDose * (-1) 
                   WHEN NEW.tpMov = 'E' THEN NEW.qtdDose 
                   ELSE 
                END
      WHERE Remedio.idRemedio = NEW.idManutencao
  END;