> 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]
