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 point in one of my applications) I get an error "ORDER BY terms must be non-integer constants"..
Offending Query :
SELECT * FROM product_detail WHERE lower("p.product_name") LIKE lower('%%') ORDER BY "p.product_name" ASC
I'm not sure if the quotes are required by SQLite or the interface (PureBasic userlib) that I'm using..
Any pointers on what might be going wrong? I've been using SQLite for a year or so and have never encountered this problem before..
Many thanks!
-- - Mitchell Vincent
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
