Problems with field named END

Problems with field named END

Postby 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
END

Can you help me?

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

Thanks.
afixcode
 
Posts: 9
Joined: Mon 15 Dec 2008 13:56

Postby 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
const
  coUseQuoteChar = TSQLConnectionOption(202); // boolean
. . .
  SQLConnection1.SQLConnection.SetOption(coUseQuoteChar, Integer(True));
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for InterBase & Firebird