Wrong SQL statement

Wrong SQL statement

am 21.03.2005 02:01:57 von Santiago Burbano

Hi

I'm trying to insert some records in a db through ADO and myODBC complains
about wrong SQL syntax.

Checking the logs, I see that the actual SQL statement that myODBC is
generating is:

INSERT INTO `a3nomedu`..`Trabajadores` ( COD_Trabajador) VALUES('000001')

Which is obviously wrong.

This is my setup:
Both client and server on same machine running WinXP SP2/MySQL 4.1.10/myODBC
3.51.11
Connection through fully configured DSN, with option=35.
Using server-side cursors, dynamic recordset and addnew/update methods.

Any idea about how to solve it?

TIA

Santiago


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org