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
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...Add k_school to the group by clause.Stephano
_
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
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 :
EDatabaseErro
