Re: [sqlite] Problem with 2.8.13

2004-05-09 Thread Mitchell Vincent
I'm not sure why you're getting "... terms must [not] be non-integer constants ..." instead of "no such column ...", but I think the first thing you should do is run 'pragma table_info' on your view to see what the column names are. I'll be surprised if there's a column named p.product_name. It's a

Re: [sqlite] Problem with 2.8.13

2004-05-09 Thread Kurt Welgehausen
I'm not sure why you're getting "... terms must [not] be non-integer constants ..." instead of "no such column ...", but I think the first thing you should do is run 'pragma table_info' on your view to see what the column names are. I'll be surprised if there's a column named p.product_name. SQLit

[sqlite] Problem with 2.8.13

2004-05-08 Thread Mitchell Vincent
Just downloaded 2.8.13 source and compiled it for windows (The Wiki documentation for doing so is very outdated, BTW). I have a view : CREATE view product_detail as SELECT * FROM products as p,categories as c WHERE c.category_id = p.category_id; When I do this query (which happens at a certain