use of double quotes in UNIDAC mysql script

[pimentel_flores]

hi Devart Team.

Im using unidac 2.70.0.11 for RAD STUDIO 2007 and mysql 5
and i have this issue, when executing the below insturuction

Code: Select all

insert into constructord (oid,va,vb) values ('xx','yyy',"  NEW ' ROOT ") ; 

i get this error

Code: Select all

#42S22Unknown column 'new ' ROOT' in 'field list'

in the past i use to use the same rutine in and old version of your mysql vcl product without any issue,

is there a way to configure the unidac components to recognize the (") double quotes as string and not a column?,

im sure the error is rised by unidac because when i run the same command from the mysql console it runs without any problem
[/code]

[Dimon]

As the UniDAC library is designed to help develop cross-database applications, therefore it formats SQL to universal form. To disable this functionality you should set the EnableUniSQL global variable from the Uni unit to False.