Query Confusion - Bug ?

dwilson837

I build a query using the 'Simple Form' interface in the config tool. I then copy and paste the SQL from the SQL form to a new query and run them both. The simple version works fine, but the copied and pasted version doesn't. I don't get any filtering on the SQL version, I get all records. Furthermore, I have to change the case of CONSUMABLES_CART to CONSUMABLES_Cart or it complains when I try to save. Am I doing something wrong or ?

SELECT Cart.* FROM CONSUMABLES_CART AS Cart WHERE (Cart.CartType='XXX')

(4.95 and 5.1 against MySQL)

Thanks,
Dylan

aware_support

SQL queries are superceded now - don't use them. Use stored procedures instead (that is, if you cannot use native Aware IM queries) and queries that run stored procedures.

dwilson837

Would be a lovely thing to alert the user in the config tool when you attempt to use them...