AnsweredAssumed Answered

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

Question asked by user24817 on Sep 6, 2016
Latest reply on Sep 7, 2016 by user19752

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?

Outcomes