Devart Forums

Posted: **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
END

Can you help me?

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

Thanks.

Posted: **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

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

Devart Forums

Problems with field named END

Problems with field named END