Am Samstag, den 15.09.2007, 18:57 +0700 schrieb Bee:
> > Nevertheless, it's MySQL that reports the error.
>
> Yes. But what did sqlDB do to the query so mysql didn't accept it?
>
> > Please set 'ParseSQL' to false and see if that helps ?
>
> Yes, it helps. Thank you.
>
> What does ParseSQL do
Nevertheless, it's MySQL that reports the error.
Yes. But what did sqlDB do to the query so mysql didn't accept it?
Please set 'ParseSQL' to false and see if that helps ?
Yes, it helps. Thank you.
What does ParseSQL do anyway? What are the benefit of it?
-Bee-
has Bee.ography at:
http://b
Op zaterdag 15-09-2007 om 01:11 uur [tijdzone +0700], schreef Bee:
> tested on sqldb using tmysql50connection class on FPC 2.0.2, Ubuntu Feisty,
> mySQL 5.0.
First of all, update to 2.2.0. And try ParseSQL := False, as Michael
said.
Joost
___
fpc-pas
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 unhandle
