Hi I have been caught with this a couple of times(V14) and wondered if anyone knows why.
If i perform the following query on my development version(single user):- 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) Anyone know why there is a difference in behaviour between the type of 4D used? Nigel Greenlee ********************************************************************** 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] **********************************************************************
