RES: [Directsql-mysql] MySQL and table component problem - ODBC 3 .51

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

Hi,
	the code is simple:
		SELECT * FROM periodo

	The problem is with ODBC 3.51. I tested with version 2.50.39.00 and it =
works perfectly.=20

Regards,


-----Mensagem original-----
De: cristian nicola [mailto:n_c...@ho...]
Enviada em: quinta-feira, 14 de fevereiro de 2002 10:09
Para: mar...@ed...
Assunto: Re: [Directsql-mysql] MySQL and table component problem - ODBC
3.51


Can you send the full sql text?

Cristian


>From: "Marcelo Muzilli (EDB)" <mar...@ed...>
>To: dir...@li...
>Subject: [Directsql-mysql] MySQL and table component problem - ODBC =
3.51
>Date: Thu, 14 Feb 2002 11:02:42 -0300
>
>Hi for all,
>     I have a problem with my application. I developed it in Delphi 5 =
using=20
>MySQL database server (MySQL ODBC 3.51) installed in a SUN Solaris =
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 =
activate=20
>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`,`desc=
r'=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,
>
>--
>Marcelo Muzilli
>Support Analyst Datacom/Access
>Ericsson Servi=E7os de Telecomunica=E7oes Ltda.
>Phone:  +55 11 3879-8119
>E-Mail: mar...@ed...
>
>
>_______________________________________________
>Directsql-mysql mailing list
>Dir...@li...
>https://lists.sourceforge.net/lists/listinfo/directsql-mysql




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com