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
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
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
3 matches
Mail list logo