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.
Problems with field named END
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:
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));