Hi Chip, > Is there a means to test for a 'Null' value in v13? > By 'Null' do not mean the default (type appropriate) value of an unassigned > field or variable. > If not, at what version does this capability exist?
In v11 the commands SET FIELD VALUE NULL and IS FIELD VALUE NULL were added: http://livedoc.4d.com/4D-Language-Reference-13.6/SQL/Is-field-value-Null.301-2502112.en.html http://livedoc.4d.com/4D-Language-Reference-13.6/SQL/SET-FIELD-VALUE-NULL.301-2502111.en.html ^ These exist in v13. In v17 (v16R4) NULL was introduced as both a data type and a command: https://blog.4d.com/new-type-supported-by-4d-null/ http://doc.4d.com/4Dv16R4/4D/16-R4/Null.301-3428288.en.html http://doc.4d.com/4Dv16R4/4D/16-R4/Data-Types.300-3317960.en.html#3428911 Hope that helps, -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************