Problems with field named END

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
Posts: 9
Joined: Mon 15 Dec 2008 13:56

Problems with field named END

Post by afixcode » Mon 15 Dec 2008 15:00

I have one table of clients. The field adress is named of END. When i try
applyupdates, show this error:

Dynamic SQL Error
Token unknown - line 2, colum 8

Can you help me?

I'm using dbx driver for interbase/firebird, version: Registred User.


Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 16 Dec 2008 08:52

It is not recommended to use field names that are same as SQL keywords. You should rename this field.

Alternatively you can set the UseQuoteChar driver option to True. In this case you can use any field names. If you are using Delphi 2007 or 2009, you can add UseQuoteChar=True to the Params property of TSQLConnection. For prior Delphi versions use the TCRSQLConnection component or set the option with the following code:

Code: Select all

  coUseQuoteChar = TSQLConnectionOption(202); // boolean
. . .
  SQLConnection1.SQLConnection.SetOption(coUseQuoteChar, Integer(True));

Post Reply