Re: [sqlite] Update-Triggers on Views

Am Mittwoch, 21. Januar 2004 19:03 schrieb Dennis Cote: [...] > --create some base tables to test > create table t1 (a, b); > insert into t1 values (1, 10); > create table t2 (a, c); > insert into t2 values (1, 100); [...] > /*** Now a better way ***/ > > --create view with column name

Re: [sqlite] Update-Triggers on Views

> I have a view that left-joins two tables, where the first table has got unique > columns. I have created an insert-trigger and an update-trigger on the view. > The insert trigger works fine. > If I do an "UPDATE testview SET xyz='test' WHERE id=1;" the update-trigger > throws an error 'SQL error:

[sqlite] Update-Triggers on Views

Hi, I have a view that left-joins two tables, where the first table has got unique columns. I have created an insert-trigger and an update-trigger on the view. The insert trigger works fine. If I do an "UPDATE testview SET xyz='test' WHERE id=1;" the update-trigger throws an error 'SQL error: c