Hi,
I have a UniConnection, a MySql driver, TuniQuery , a MariaDb database and a grid. Simple scenario.
When I change a string value in the Dbgrid column with a "Test ' 12" (a single quote inside the text) I have a sintax error in Sql on Post record.
The same error using dbForge Studio for MySQL.
Why this error on thi simple case? Why UniDac don't manage correctly the escape?
(The same database and Grid with a FIredac connection works )
Please send me a solution,
Thanks in advance
MariaDb error for quote in editor
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: MariaDb error for quote in editor
Hi,
no solution?
no solution?
Re: MariaDb error for quote in editor
Thank you for the information. The issue and investigation is in progress. We will inform you when we have any results.
Re: MariaDb error for quote in editor
Unfortunately, we haven't been able to reproduce the issue using your description of it, and neither have received reports on such issue from our users yet. The issue may have been caused by something other than MyDAC code. The only way to investigate the issue is to look into your code where the issue can be reliably reproduced. Please create and send us such code example. After looking into your code example, we'll fix the issue if it's caused by our MyDAC code.
Please create a sample project demonstrating the incorrect behavior and send it to us through the contact form (https://devart.com/company/contactform.html), along with the script for creating database objects. Please also specify the exact version of your MariaDB server.
Please create a sample project demonstrating the incorrect behavior and send it to us through the contact form (https://devart.com/company/contactform.html), along with the script for creating database objects. Please also specify the exact version of your MariaDB server.