Greetings,
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.
Using the DbNavigator 'post' button, 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?
My Ref is 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]
