Hi Jon, you should do two things: 1) set ParseSQL:= False, to solve the problem temporarily. (Then filtering and updating won't work) 2) submit a bug-report on www.freepascal.org/bugs with this query. Don't forget to mention that you're using MySQL. And tell if 1) works. ;)
On Sat, 2006-04-22 at 11:01 -0700, Jon Foster wrote: > Using TMySQL40Connection I tried to use the following query: > > SQLQuery1.sql.text:='SELECT organizations.name as org, > tests.name as test '+ > 'FROM tests INNER JOIN organizations '+ > 'ON tests.organization=organizations.id '+ > 'WHERE result<>''PASS'' '+ > 'ORDER BY tests.name'; > > When I try "open" the query I received an error indicating that I had an > error "near INNER JOIN ...". If I paste the query into the MySQL client > it works. I also removed the word "inner" and tried it but received the > same message except that it pointed to "join" instead of "inner". > Rewriting the query like below it worked: > > SQLQuery1.sql.text:='SELECT organizations.name as org, > tests.name as test '+ > 'FROM tests, organizations '+ > 'WHERE tests.organization=organizations.id AND > result<>''PASS'' '+ > 'ORDER BY tests.name'; > > Is there some filtering of the SQL that might be corrupting my query? > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
