[Directsql-mysql] MySQL and table component problem - ODBC 3.51

[Marcelo M. (EDB) <mar...@ed...>]

Hi for all,
     I have a problem with my application. I developed it in Delphi 5=20
using MySQL database server (MySQL ODBC 3.51) installed in a SUN Solaris=20
2.7.
     The problem is: I can't activate the table component. There is a=20
problem with the internal SELECT from the component. When I try to=20
activate the table the following problem occurs:

General SQL error.
[MySQL][ODBC 3.51 Driver][mysqld-3.21.33b-log]parse error near=20
'`id`,`dia`,`mes`,`ano`,`pernormal`,`pernoturno`,`totdia`,`local`,`descr'=
=20
at line 1.

     Why I can't do this in my application and I can do this in the SQL=20
explorer?
     Any sugestion?

Thanks in advance,

--=20
Marcelo Muzilli
Support Analyst Datacom/Access
Ericsson Servi=E7os de Telecomunica=E7oes Ltda.
Phone:  +55 11 3879-8119
E-Mail: mar...@ed...