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?