Re: [sqlite] Possible View bug

2008-08-10 Thread 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

Re: [sqlite] Possible View bug

2008-08-09 Thread 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

[sqlite] Possible View bug

2008-08-09 Thread 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