Subject Re: SQL WHERE Clause Not Working Since Upgrade to Plus 11 From Ken Mayer <dbase@nospam.goldenstag.net> Date Wed, 20 Sep 2017 06:34:25 -0700 Newsgroups dbase.getting-started On 9/20/2017 6:30 AM, Akshat Kapoor wrote: >> This is incorrect. There is an application-wide setting: >> >> set autonullfields off // means don't use nulls >> set autonullfields on  // means use nulls >> >> queryname.rowset.autoNullFields := false // turn off null fields for a >> specific rowset object >> > > This works. I just checked it. > > Maybe I was over cautious in assigning values to each and every field > after beginappend() > > As null plays havoc with coding and have seen multiple cases on the > newsgroup due to this Well, you're doing more work than needed, honestly. The autoNullFields setting works perfectly ... Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm