使用VALUE作为列名称,错误。 [英] Using VALUE as column name, error.
本文介绍了使用VALUE作为列名称,错误。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图将一条记录插入一个名为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屋!
查看全文