1 2 Previous Next 15 Replies Latest reply on Sep 7, 2016 7:39 PM by user19752

    Anyone else seeing or know a solution to executeSQL crashing when using LIKE

    user24817

      Im running Filemaker Pro Advanced 14.0.6 on a fully unto date Macbook Pro.  Getting consistent crashing when using executeSQL (calc not script step).  For example:

       

      ExecuteSQL (

      "SELECT a.\"__ID\"

      FROM \"Complaint\" a

      WHERE a.\"dateCREATED\" LIKE ?"

       

      ; "" ; ""

      ; "2016" 

      )

       

      No problems but:

       

      ExecuteSQL (

      "SELECT a.\"__ID\"

      FROM \"Complaint\" a

      WHERE a.\"dateCREATED\" LIKE ?"

       

      ; "" ; ""

      ; "2016%" 

      )

       

      Crashes instantly.  The difference is the "%" at the end which makes the magic of LIKE work.

       

      Anyone else seeing this

       

      Anyone ...

       

      Buler?

        1 2 Previous Next