AnsweredAssumed Answered

ODBC: SELECT NULL AS causes syntax error

Question asked by ranja on Feb 25, 2013

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?

Outcomes