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.