Devart Forums

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

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.