Adrian, I honestly believe this to be a bug and hope that in the future it will be fixed.
Below does not work: $vc_exclude:=New collection //make a simple empty collection $es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude) Here are few ways around it: Option 1 - Check and do something different $vc_exclude:=New collection //make a simple empty collection If($vc_exclude.length>0) $es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude)// Could have other fields as well Else $es_MySel:=ds.myTable.all() //Or a query without the no in End If Option 2 - Add a fixer value to the collection $vc_exclude:=New collection //make a simple empty collection If($vc_exclude.length=0) $vc_exclude.push("")// Add a value to the collection that I would never expect to find (of the right type) End If $es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude)// now the query will work Option 3 - take the in away from the query $vc_exclude:=New collection //make a simple empty collection $es_MySel:=ds.myTable.all().minus(ds.myTable.query("myField in :1";$vc_exclude)// now the query will work The .all() above could be the a .query() if you are trying to query on multiple properties. Personally I like option 3 best. Regards, Dougie ________________________________________________________ telekinetix Limited- J. Douglas Cryer Phone : 01234 761759 Mobile : 07973 675 218 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE Email : jdcr...@telekinetix.com Web : http://www.telekinetix.com <http://www.telekinetix.com/> ________________________________________________________ ********************************************************************** 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 **********************************************************************