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
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
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
_
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
One of the most basic paramater for database connection: port, is not
provided in sqlDB. While dialect property which is not common outside FB/IB
is provided. Is there any particular reason for this? Or should I make a
feature request on this?
BTW, how to set port for mysql connection using sq
