使用VALUE作为列名称，错误。 [英] Using VALUE as column name, error.

问题描述

我试图将一条记录插入一个名为VALUE的列的表中，但不断收到错误



无效使用关键字。令牌：VALUE ）VALUES（



我是Delphi + DB2的新手，并尝试在和[]中封装查询以绕过保留字但仍然没有运气。



提前致谢！

Im trying to Insert a record into a table with a column named "VALUE", but keep getting the error

"Invalid use of keyword. Token: VALUE) VALUES ("

Im new to Delphi + DB2, and have tried encapsulating the query in "" and [] to bypass the reserved word but still no luck.

Thanks in advance!

推荐答案

尝试使用双引号，如下所述： SQL标识符的封装在Double中行情 [ ^ ]。有关保留字的更多信息：保留的模式名称和研究rved words [ ^ ]

Try to use double quotes, as is described here: Encapsulation of SQL Identifiers in Double Quotes[^]. More about reserved words: Reserved schema names and reserved words[^]

我最后将列重命名为非保留字并修复了问题。不确定为什么双引号在DB2中不起作用。我知道这不是一个确切的解决方案，但如果其他任何人遇到同样的问题，这是一个解决方法。

I ended up renaming the column to a non-reserved word and it fixed the issue. Not sure why the double quotation's wouldn't work in DB2. I know this isn't an exact solution, but its a work around if anyone else is experiencing the same problem.

这篇关于使用VALUE作为列名称，错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！