When the field is null, it's not index. Query won't work well. I guess the single user mode would use non-index query by loading record.
I used different approach by using set that work well and doesn't need to load every record just for checking if it's null. Alan Chan 4D iNug Technical <[email protected]> writes: >Anyone know why there is a difference in behaviour between the type of 4D used? ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
