maybe because the array [] is not empty when there is a an empty string in it. and the query, in the second case is looking for empty string values, or just string values
> > NOT(IN []) > versus > NOT(IN [""]) ------------ Hell is other people Jean-Paul Sartre ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************