Hello lists, This amends my third re-mail on this topic.
Sorry about that: A point to clarify is that the writes are done using the update button of the DbNavigator. I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access, etc & etc. I have a very basic project using OOP, Delphi (6), ODBC, ADO & Data Aware Components, Access and MySQL(4.1). In fact I have two projects, identical except that one connects via odbc to Access and the other to MySQL. Briefly: The project connects with TADOConnection, TADOTable and TDataSource, and consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only), and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2, this with full read/write options. Attempts to write to Access succeed where attempts to write to MySQL fail, all other things being equal. The MySQL error return states: "Check the manual that corresponds to your MySQL server version for the right syntax to use near ','detail' SET '(' " So far as I can see, all MySQL permissions exist for read/write access to the DB. My confusion arises from the fact that to give entry level experience, I chose data aware controls which I presumed would not need coding to function at a basic level. This works with Access but apparently not with MySQL. Clearly I am missing something fundamental regarding differences between MySQL's and Access's interactions with data aware components. Can anyone suggest what it is that I am missing and how can I coax my project to write to MySQL? Please can you quote my Ref 'Query 2003048'. With thanks in anticipation, john John Barrington [EMAIL PROTECTED] +27 11 6489876 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]