AnsweredAssumed Answered

Query works remotely, but not in FMP (Get "?")

Question asked by MorkAfur on May 12, 2015
Latest reply on May 12, 2015 by MorkAfur

Title

Query works remotely, but not in FMP (Get "?")

Post

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.

- m

Outcomes