Page 1 of 1

use of double quotes in UNIDAC mysql script

Posted: Wed 16 Feb 2011 23:06
by 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]

Posted: Thu 17 Feb 2011 10:04
by 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.