Naomi,

Have you tried creating a new CA class from scratch using the statement with table names spelled out? May be the previous CA got 'cursed'.

I will try it out. Let u know outcome. Thanks.

If this will not help, I think the problem may be in MySQL driver you used.

I am using MySQL ODBC 3.51.27.

Dennis