[fpc-pascal] sqldb query error on group by with where clause

[Michael Van Canneyt]

On Sat, 15 Sep 2007, Bee wrote:

> This query...
> 
> select k_province, k_city, k_school, count(file_id), sum(amt_student) from
> upload_log where (date(upload_time)='2007-09-14') group by k_province, k_city
> having k_province='205' and k_city='205031';
> 
> raises exception...
> 
> An unhandled exception occurred at $0808E144 :
> EDatabaseError : Error executing query: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the right
> syntax to use near 'group by k_province, k_city having k_province='205' and
> k_city='205031';)' at line 1

Nevertheless, it's MySQL that reports the error. 
Please set 'ParseSQL' to false and see if that helps ?

Michael.