Did this article resolve your question/issue?


Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025



Error 10713 when running a SQL query

« Go Back


Article Number000080990
EnvironmentProduct: OpenEdge
Version: 10.2.x
OS: All supported platforms
Other: SQL
Question/Problem Description
Error only occurs with a specific query.
Sample query,
UPDATE pub.<table> 
SET <field> = '' 
WHERE NOT ('' = '' OR '' IS NULL)
AND <field> = <value>
AND 1 = 1
Steps to Reproduce
Clarifying Information
SQL client access is installed.
Error Message[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]
Syntax error at or about (statement excerpt). (10713)
NativeError: -210056
SQLState: HY000
Source: pgoe1023.dll
Defect/Enhancement Number
In 102B and earlier releases, the IS NULL predicate required a field name at its left-hand side. In OE 11.x releases, this limitation was lifted. 
Upgrade to OpenEdge 11.x where this limitation has been lifted.
Modify the query to include the field name. 
Last Modified Date8/11/2017 5:59 AM