> 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'. > I need more information to help you solve this problem: 1. Did you use default setting of MyODBC?What version? Show me your connection string. 2. TAdotable:what kind of locktype used?
Try to save use delphi Dataset command like: TAdotable1.UpdateBacth(); //if you use ltBacthOptimistic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]