Linux SQL syntax Problem

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
multimesut
Posts: 18
Joined: Mon 28 Nov 2011 18:04
Location: Türkiye

Linux SQL syntax Problem

Post by multimesut » Mon 18 Jan 2021 12:05

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Linux SQL syntax Problem

Post by ViktorV » Wed 20 Jan 2021 05:19

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.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Linux SQL syntax Problem

Post by ViktorV » Tue 26 Jan 2021 14:58

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.

Post Reply