1 Reply Latest reply on Aug 12, 2015 2:07 PM by wimdecorte

    FMP12 SQL Now Follows the Rules


      Just for info,


      We just upgraded a system from FileMaker 11 to 13,  and got a surprise


      Queries from a third party application started to break, since FileMaker now honors SQL things, like Data Type,  and NULL


      e.g.  so  things like  " WHERE Number = '1' " no longer work  ( the quotes )


      and  " WHERE Number != 1 "  now fails,  if any records are blank  (  you need  WHERE Number != 1 OR Number is NULL )