Page 1 of 1

field named fulltext make error on update

Posted: Tue 03 Mar 2009 08:24
by delphix
hi
my version is 5.20 and delphi 7
mydac for mysql

myconnection -> myquery -> datasource - > datagrid

when update directly from datagrid every thing is ok but when update field named fulltext i got an error about sql syntax

any help for this problem.
:cry: :cry:

Posted: Tue 03 Mar 2009 12:02
by Dimon
To solve this problem try to set the TMyQuery.Options.QuoteNames property to True.

Posted: Tue 03 Mar 2009 13:41
by delphix
Very very thanks it worked now
very amazing

i never seen as this component.

the reason of this error cause fulltext is reserved word in mysql.

thanks again.