"Shawn Wilsher" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I think I managed to hit a bug with sqlite and views. I try to insert > onto the view (I have a trigger setup to handle it), but sqlite gives > me the following error: > no such column: from_visit > > Here is test file that demonstrates the bug: > http://files.shawnwilsher.com/2008/8/9/test-bug.c
Your trigger uses a curious syntax for SQL INSERT statement, along the lines of insert into tableName values (columnName1 = value1, columnName2 = value2); This is not a valid syntax. The correct way is insert into tableName(columnName1, columnName2) values (value1, value2); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users