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

Marc Santhoff M.Santhoff at t-online.de
Sat Sep 15 17:40:49 CEST 2007


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 anyway? What are the benefit of it?

This question can be answered by activating logging on the mysql server.

The log will show much detail, so beware of filling up your disk drive.

HTH,
Marc





More information about the fpc-pascal mailing list