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:

 

GetAs(<FIELD_NAME>, DEFAULT)

 

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?

 

TIA

Outcomes