1 Reply Latest reply on May 12, 2015 10:39 AM by MorkAfur

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

    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