Devart Forums

Trying to load a customer sql table from a Dbase table. The sql table has a fieldname 'Desc' .

I get an error when I try to load with the following:

DM.tbsql.Append();
DM.tbsql.FieldByName('Desc').AsString := DM.tbInOut.FieldByName('Desc').AsString ;
DM.tbsql.Post();


The error is as follows:

Project LoadData.exe raised exception class EMSError with message 'Incorrect syntax near the keyword 'desc'.'.

I get the same error with another sql table with the fieldname 'break'.

Using SDAC 2.45 for Delphi 7.

Any ideas?

Please set MSQuery.Options.QuoteIdentifier to True

Thanks, It's works.