field named fulltext make error on update

delphix · Post by **delphix** » Tue 03 Mar 2009 08:24

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.

Dimon · Post by **Dimon** » Tue 03 Mar 2009 12:02

To solve this problem try to set the TMyQuery.Options.QuoteNames property to True.

delphix · Post by **delphix** » Tue 03 Mar 2009 13:41

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.