Hii,
I have a MySQL server running on linux and there is an error when using a command like

SQLEXEC(MConnection, "Select * From Sales", "Temp")

but it works fine if I run it in Windows server.

Later I find out it works if I changed the "Sales" into "SALES" (Capital letters)

SQLEXEC(MConnection, "Select * From SALES", "Temp")

Plz, advise me to solve this problem. Thanks.