gdurniak

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 )

 

Interesting

 

greg

Outcomes