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

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

Postby 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
savoweb
 
Posts: 3
Joined: Thu 14 Jun 2007 14:39

Postby 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.
Challenger
Devart Team
 
Posts: 925
Joined: Thu 17 Nov 2005 10:53


Return to dbExpress driver for InterBase & Firebird