Devart Forums

Posted: **Thu 25 Jan 2018 16:22**

Hey!

I'm still trying out your components. Now I want to use UniDAC and MySQL.
If I do

AnyTable.SQL.Text:= 'SELECT * FROM automat WHERE name="Test"'

all double quotes will be replaced by

Code: Select all

This is not a single quote, it's a quote for table names, not for strings.
The same happens when

Code: Select all

AnyTable.Connection.MacroByName('any_condition').Value:= 'name="Test"';

How can I solve this Problem?

Posted: **Thu 25 Jan 2018 16:56**

To solve the issue, please try to set the EnableUniSQL global variable from the Uni unit to False. For example:

Code: Select all

initialization
  EnableUniSQL := False;

Posted: **Thu 25 Jan 2018 17:08**

Yeh, but then the macros will not work anymore :-/

Code: Select all

SQL.Text:= '{select_clause}';

Posted: **Mon 29 Jan 2018 13:49**

Since UniDAC is designed to develop applications that support various databases, it converts SQL into universal format. Therefore, for MySQL UniDAC replaces the character " with `.
UniDAC uses the characters "{" and "}" to specify macros within SQL queries. If the SQL parser finds any expression in {}, it replaces this expression with a predefined macro. A global variable EnableUniSQL is responsible for the above functionality. Therefore, when setting EnableUniSQL to False, the conversion of SQL into universal format will be disabled, but macros will stop working either.

Devart Forums

MySQL double quotes get removed

MySQL double quotes get removed

Re: MySQL double quotes get remove

Re: MySQL double quotes get remove

Re: MySQL double quotes get removed