the "map null to blank" property was originally introduced in v11, as a way to tell SQL that pre-existing NULLs (which could typically be created by adding fields) should not be considered NULLs in SQL. otherwise, as far as SQL is concerned, NULLs should never be mapped to blanks. (that is why the CREATE TABLE command does not allow this property to be enabled)
> The documentation for Query by Attribute discusses at length how a # query > performs with or without the Map NULL values to blank values checked. this passage was added in v16 http://doc.4d.com/4Dv16R4/4D/16-R4/QUERY-BY-ATTRIBUTE.301-3317528.en.html c.f. http://doc.4d.com/4Dv15/4D/15/QUERY-BY-ATTRIBUTE.301-2018639.en.html and the you immediate notice that "on" is considered the "4D way" and "off" the "SQL way". as for the question, > I do not see this checkbox in the field Explorer window for an Object field. > Am I missing something here? It is there for other types of fields but not > Object fields. maybe you need to check the version. ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************
