I using a CA with mySQL using the 3.51 ODBC driver for mySQL in the connection string. The CA fills correctly but I find that if I manually edit data (or programmatically for that matter) when I move off the field, it reverts and no update occurs either to the CA or to the table. TABLEUPDATE() does not change the data either.

Is there a known bug with the mySQL driver that I may not be aware of? Or does this sound like a common problem due to some setting in my CA class that I have missed? Any ideas?

Paul Montgomery