10.1B SQL Select field1, NULL from Table

Posted by Mark.Ward on 23-Oct-2010 10:35

Does 10.1B ODBC driver support the ability to query a table and specify an explicit NULL value in the results?

For example

Select

     pub."table".field1 Code,

     null SecondCode

from

     pub."table"

when executing the above I get the following ODBC error

Syntax error in SQL statement at or about "null FROM pub."table" " (10713)

State:S1000,Native:-210056,Origin:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]

All Replies

Posted by Mark.Ward on 24-Jan-2011 14:31

Our solution has been to move off OpenEdge and onto Microsoft SQL Server 2008 r2.

This thread is closed