Thanks I was looking (in v13) for a boolean test like Nil().
On Fri, 1 Jun 2018 17:10:32 +0000, Timothy Penner via 4D_Tech wrote: > 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:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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:[email protected] **********************************************************************

