On Fri, Sep 23, 2016 at 11:35 AM, Nigel Greenlee <[email protected]> wrote: > > Query (or query selection) ([DATA];[DATA]UUIDField=(“0”*32);*) > Query (or query selection) ([DATA];|;[DATA]UUIDField=“”) > > This correctly finds all the records that have nothing in the UUID (this is a related record identity not the key field on the table which cannot be nul). > > However if I perform the same connected to a server(Client) then it finds zero records. > > Now i already have a UTIL( is uuid nil) and if change the above to > > Query by formula([DATA];UTILISUUIDNIL(;[DATA]UUIDField)) //This works fine even though it tests in the same way(sort of)... > > $0:=($1=“”) | ($1=(“0”*32)
I use fllowing test for empty UUID: $0:=($1="") | ($1=(32*"0")) | ($1=(16*"20")) It would be nice if 4D publish how it maps special cases (like undefined and 0.) -- Peter Bozek ********************************************************************** 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] **********************************************************************
