Re: [sqlite] Possible View bug

[Shawn Wilsher]

On Sat, Aug 9, 2008 at 9:39 PM, Igor Tandetnik [EMAIL PROTECTED] wrote:
 Your trigger uses a curious syntax for SQL INSERT statement, along the
 lines of
I was hoping it was a bug in my code and not in SQLite.  Thanks for
spotting my fascinating syntax.

Cheers,

Shawn
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Possible View bug

[Shawn Wilsher]

Hey all,

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

Any advice?

Cheers,

Shawn Wilsher
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible View bug

[Igor Tandetnik]

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