[sqlite] update statements inside select...case inside triggers

[Simon Naunton]

Hi All,

I'm trying to do the following:

CREATE TRIGGER trigger_name AFTER UPDATE ON table
BEGIN
  SELECT CASE
    WHEN a_condition THEN
      UPDATE another_table SET a_field=a_value WHERE yet_another_condition
    WHEN another_conditon THEN
      UPDATE another_table SET a_field=another_value WHERE yet_another_condition
    END; 
END

When I try to create the trigger it returns an error before update (or
similar - sorry do not have access to my PC at the moment to get the
exact error).

Can sqlite3 do the above?

I have worked around it using:

CREATE TRIGGER...
BEGIN
   UPDATE (SELECT CASE...) WHERE (SELECT CASE...);
END

But it is harder to read and perhaps less efficient.

Thanks in advance,

Si.