The SQL CAST function no longer works in Select by Attributes.
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM036699
已提交
July 10, 2008
上次修改时间
June 5, 2024
适用范围
No Product Found
找到的版本
9.3
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
No Public Explanation
解决办法
If you use NUMERIC, at 93 you now have to give a precision and optional scale, just as you would if it were in a CREATE TABLE statement. It should be something like:CAST("field1" as NUMERIC(10,2)) > 5.7Or use the INTEGER keyword - it doesnt require scale and precision.