You have case sensitive MySQL server and have to specify the names of SQL objects (DBs, tables, columns, etc as theya re defined).
>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.
--sb--