> I still do not get why the R4 documentation for Query by attribute discusses how a # query will function if the "Map null > to blank” checkbox is or is not checked it the checkbox does not exist for an object field.
John, random thought: Object fields aren't supported in 4D's SQL. So any SQL-specific features and such are completely meaningless for ojject fields. And by "not supported" I don't mean ignored. If you do SELECT * FROM MyTableWithAnObjectField; 4D freaks out because there's an object field. At least as late as R3. This has come up a few times here and other people have looked at this in detail. (I think that Jeff Kain, at thel least, has the details.) In my case, I had to rewrite my ugly little SQL browser to scan the field list for object fields and remove them from statements. That's okay for my needs, but I'm not using 4D's SQL for anything real any longer. ********************************************************************** 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] **********************************************************************
