> Le 1 juin 2018 à 20:39, Chip Scheide via 4D_Tech <[email protected]> a > écrit : > > I meant - I was looking for a command which behaved like Nil(), but for > Null.
Hi Chip, I had a bad recent experience with a legacy db in which check box "convert Null to empty" was sometimes on, sometimes off… The use of QUERY command, in that situation, is risky: //example with date QUERY($table_p->;$field_p->=!00/00/0000!) $empty_l:= Records in selection($table_p->) QUERY($table_p->;$field_p->#!00/00/0000!) $notEmpty_l:= Records in selection($table_p->) ASSERT(Records in table($table_p->)=($empty_l+$notEmpty_l);"data integrity or bad Null setting") It's checked everywhere now. In a brand new DB, and *knowing what strategy has been adopted about Null use*, things could be different. -- Arnaud de Montard ********************************************************************** 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] **********************************************************************
