Fileds name uppercase
Posted: Wed 24 Oct 2018 16:12
Hi All,
I have this simple query for a MySql database:
Select distinct Anno From aperture where Aperto=1 order by id desc
My application has been installed on a Windows machine and I haven't had any problems.
Now, I have my application on a Virtual Machine on Mac and I want to connect to MySql installed on Mac. I have an error when this query is executed: error is on id field of the order clause; the id field in table is named ID (all uppercase).
There's a way to solve this kind of problems? Or I need to check all my fields?
Thanks.
I have this simple query for a MySql database:
Select distinct Anno From aperture where Aperto=1 order by id desc
My application has been installed on a Windows machine and I haven't had any problems.
Now, I have my application on a Virtual Machine on Mac and I want to connect to MySql installed on Mac. I have an error when this query is executed: error is on id field of the order clause; the id field in table is named ID (all uppercase).
There's a way to solve this kind of problems? Or I need to check all my fields?
Thanks.