AnsweredAssumed Answered

JDBC SQL Query with Two (or more) Container Fields Fails with NullPointerException

Question asked by fmpdude on May 17, 2016
Latest reply on Jun 24, 2016 by TSGal

I am trying to create a SQL (JDBC) query that will retrieve multiple container fields from a table using the nice FMP syntax:




One container field in the query, similar to the SQL guide works fine, but two or more will crash with NullPointerExceptions.


Is there a workaround for this?


Don't know if TSGal is aware of any bugs SELECTing multiple container fields, and getting NPEs, but it's easily reproducible in FMPA 14.


I didn't see anything in the documentation that says I can't SELECT multiple continaer fields using GetAs(<FIELD_NAME>, DEFAULT), but maybe I missed it?