0 Replies Latest reply on Feb 25, 2013 11:14 PM by ranja

    ODBC: SELECT NULL AS causes syntax error

    ranja

      Summary

      ODBC: SELECT NULL AS causes syntax error

      Product

      FileMaker Server

      Version

      12.02.232

      Operating system version

      Windows Server 2003R2 Japanese Edition

      Description of the issue

      A SQL syntax, such as

      SELECT Field1, NULL AS Field2 FROM Table1

      worked all right with FileMaker Server 9 Advanced.

      However, when I targeted to FileMaker Server 12 Advanced, it now returns a syntax error:

      [FileMaker][FileMaker] FQL0001/(6:21): There is an error in the syntax of the query.

      I found I can use the syntax

      SELECT Field1, '' AS Field2 FROM Table1

      instead, but an empty string should be different from NULL, shouldn't it?