Feedback
 
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

 


Article

Error 10713 when running a SQL query

« Go Back

Information

 
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
Cause
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. 
Resolution
Upgrade to OpenEdge 11.x where this limitation has been lifted.
Workaround
Modify the query to include the field name. 
Notes
Attachment 
Last Modified Date8/11/2017 5:59 AM