TClientDataSet+TProvider not resolved insert/update of field with name is "DESC"

savoweb · Post by **savoweb** » Thu 14 Jun 2007 14:56

If use this table:
create table TESTCRLAB
(
ID INTEGER NOT NULL PRIMARY KEY,
"DESC" VARCHAR(50) NOT NULL,
OTHER VARCHAR(50)
)

Set TSQLDataSet.CommandText := 'select * from TESTCRLAB';
Connect TClientDataSet + TDataSetProvider and create persistent fields.

After ApplyUpdate, on IDE with stop exception:
ProgramName raised exception class EIBCError with message'
Dynamic SQL Error
Token unknown - line 2, colum 8
DESC'

After raise not write Record into table, if use Borland driver no problem.

Use FB 2.01 - BDS 2006 Arch. - D32 Personality

Challenger · Post by **Challenger** » Fri 15 Jun 2007 11:32

We have fixed this problem. It will be included in the next build of DbxIda. To make dbExpress quote table names and fields, you should set the UseQuoteChar extended option. Note that in this case you should write name of the table in SELECT SQL statement in the case it was created.