David,
>After strtran-ing the cUpdateInsertCmd in the BeforeUpdate event as suggested, it works flawlessly. Thanks for pointing me to the right direction! Since I use only one table in the CA, the following code does the job:
>
>cUpdateInsertCmd = strtran(cUpdateInsertCmd,this.Tables,this.Tables,1,1,1)
>
I'm glad that worked. So MySQL is case-sensitive on table names? I assume you don't have the problem on CursorFill() because you're putting the entire Select statement, including table name, into the .SelectCmd property for that.
However, if needed for generic code, you can do the same trap in .BeforeCursorFill() by changing the cSelectCmd incoming parameter (which also persists for CursorRefresh() ). Trapping the cSelectCmd this way allows for generic code to add on extra stuff to the pre-programmed SelectCmd, such as adding a dynamic ORDER BY clause or a WHERE clause (or addition to an existing WHERE clause).