field named fulltext make error on update

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
delphix
Posts: 2
Joined: Tue 03 Mar 2009 08:06
Location: Libya
Contact:

field named fulltext make error on update

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.
:cry: :cry:

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 03 Mar 2009 12:02

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

delphix
Posts: 2
Joined: Tue 03 Mar 2009 08:06
Location: Libya
Contact:

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.

Post Reply