Query works remotely, but not in FMP (Get "?")
I have a query that works fine connected to FMP from a remote data connection. Yet, in FMP, I get the maddening, and unhelpful "?" when I try the query in the data viewer.
Here's the working (remotely) query that gives me the single row expected (but doesn't work in FMP itself):
ExecuteSQL ( "select VENDORS.Vendor FROM BIDS, BIDS_VENDORS, VENDORS, BID_COMPLIANCE
where BIDS.BID_PK = BID_COMPLIANCE.BC_BID_FK and
BIDS_VENDORS.VEN_FK= VENDOR_ID and
BIDS_VENDORS.BIDS_VEN_PK = BID_COMPLIANCE.BC_BID_VENFK and
BID_COMPLIANCE.BC_BID_Has_Insurance = 'Yes' and
BID_COMPLIANCE.BC_BID_TERMS_OK = 'Yes’" ; "" ; ¶ )
Since the query works (remotely), there must be something FMP wants, but doesn't know how to ask for it...
Thanks in advance for suggestions.
Have no idea, but I copied and pasted the same query again into the Calculation Field and it works now.