Subject Re: SQL WHERE Clause Not Working Since Upgrade to Plus 11 From Bryce Westover <bryce@films101.com> Date Wed, 20 Sep 2017 20:42:33 -0400 Newsgroups dbase.getting-started My original code is working again now that I am aware of the null vs blanks issue. Thanks again to all who contribute here.  You do us a great service. Bryce Ken Mayer Wrote: > On 9/20/2017 12:37 PM, Mervyn Bick wrote: > >> > >> If Akshat must do things this way, perhaps this is where a Data Module > >> might be handy, with a custom append option that sets up default > >> values automatically ...? > > > > Makes sense.  Akshat is already using datamodules so he could well do > > this. I, on the other hand, prefer to only write fields where I have > > data to store and to deal with any null values that may arise. > > > > Twelve programmers, a dozen solutions. :-) > > Sure. Of course in the end, as long as you get the results you want, > that's what matters. But ... > > 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