| Subject | Re: SQL WHERE Clause Not Working Since Upgrade to Plus 11 |
| From | Ken Mayer <dbase@nospam.goldenstag.net> |
| Date | Wed, 20 Sep 2017 16:37:07 -0700 |
| Newsgroups | dbase.getting-started |
On 9/20/2017 2:59 PM, Bruce Beacham wrote: > On 20/09/2017 14:30, 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. > > It doesn't work when you have a lookuprowset on a field on a rowset to > which you append a record. PLUS mis-reads the type of the field when > trying to assign a non-null empty value. Have you got a case you can post to R&D for this? 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 | |