Thanks Sergey! Since the MySQL database is hosted by an external ISP, I may have difficult to setting the lower_case_table_names system variable at the MySQL end. I am wondering if there is a way that could be done at the client side to make it works. Since the select statement works, which means somehow the lettercasing in the select selectment is correct, just that the update statement has this problem. I am not sure if that has something to do with the cursoradapter or the ODBC driver or my coding. Btw, I use the cursoradapter builder to build the cursoradapter that i use in this scenario. Cursoradapter is new to me perhaps I could specify my own update statement for the cursoradapter which would preserve the casing... any suggestion?

>>I am using MySQL ODBC Driver 3.51.11 to connect to a MySQL database running on Linux. I have a form with a data environment which have a cursoradapter connected to a table in the MySQL database via the MySQL ODBC DSN. There is no problem selecting records from a table, but when updating the records in the same table, there is an error stating that the table is not found, and i notice that the table name is in all lowercase while the physical table in MySQL is in mixed case. I understand that the table name of MySQL on Linux is case sensitive, I am wondering if the error is due to lettercasing or some other reason. Any advise is welcome!
>>
>
>David,
>
>See http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html