FMP12 SQL Now Follows the Rules

Discussion created by gdurniak on Aug 12, 2015
Latest reply on Aug 12, 2015 by wimdecorte

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 )