AnsweredAssumed Answered

ExecuteSQL fail.. WHY?

Question asked by coherentkris on May 24, 2018
Latest reply on May 26, 2018 by beverly

ExecuteSQL ( "SELECT \"__skFoodFotoID\", \"_fkBeamerNumber\", TypeOfMeal FROM FoodFoto WHERE FotoIsTurked IS NULL" ; "" ; "" ) returns ?.

 

This below returns expected values...

ExecuteSQL ( "SELECT \"__skFoodFotoID\", \"_fkBeamerNumber\", TypeOfMeal FROM FoodFoto" ; "" ; "" )

 

The only difference is the where clause.

 

There are in fact rows in the table where the field is empty.

 

FoodFoto::FotoIsTurked is set as number with no auto enter.

 

The column contains 1 or empty.

 

Been at it a long time...Maybe its time to go to sleep.

Outcomes