Hello, I'm getting an error in the sql below. but there is no problem on the windows side. I got the log below from dbmonitor.
SQL;
select *,(case pin when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as pins,(case timerule when '0' then 'Etkin Değil' when '1' then 'Etkin' end )as time
from company_call_rules u where status=:p_status and deleted=:p_deleted and companyid=:p_companyid
Parameters;
p_status WideString[1] '1'
p_deletes WideString[1] '0'
p_companyid Byte 12
Error;
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? '1'nd deleted=? '0'nd companyid=?12' at line 2
Linux SQL syntax Problem
Re: Linux SQL syntax Problem
Unfortunately, we could not reproduce the issue.
In order for us to be able to give you a detailed answer, please compose a small sample demonstrating the described behavior and send it to us through the contact form https://devart.com/company/contactform.html including the scripts for creating database objects. Also specify the version of the MySQL server that you are using and what do you mean by the phrase 'the windows side' - the location of the MySQL server or platform where the application runs.
In order for us to be able to give you a detailed answer, please compose a small sample demonstrating the described behavior and send it to us through the contact form https://devart.com/company/contactform.html including the scripts for creating database objects. Also specify the version of the MySQL server that you are using and what do you mean by the phrase 'the windows side' - the location of the MySQL server or platform where the application runs.
Re: Linux SQL syntax Problem
Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.