Devart Forums

Hi

I am currently evaluating the MySQL components with a view of purchasing but have the following problem.

I've got a rather large query that works fine on a MySQL 3.23 database, but when i try and run the query on a MySQL 5 database i get the following error :

EMyError

Exception message : #42S22 unknown column xxxx in on 'clause'

Any ideas/suggestions/comments welcome.

TIA
bluenose

Seems to be a pattern to it :

All queries that use LEFT JOIN seem to be failing with the above message.

Please supply us with the exact MyDAC version you are using and the exact steps to reproduce the problem.
Check the text of the query that is sent to the server. You can do this using the TMySQLMonitor component (the tfMisc trace flag should be enabled) or using MySQL logs (run your MySQL server with the --log=log_file_name.log option).

It seems to be problem with MySQL and the way join are interpreted!