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

    FMP12 SQL Now Follows the Rules

    gdurniak

      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 )

       

      Interesting

       

      greg