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:[email protected]
**********************************************************************