will do.

>>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 would suggest that you post the question in the new thread.