10.1B SQL Select field1, NULL from Table - Forum - Community Groups - Progress Community

10.1B SQL Select field1, NULL from Table

 Forum

10.1B SQL Select field1, NULL from Table

  • 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]

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