Subject Re: SQL WHERE Clause Not Working Since Upgrade to Plus 11 From Bruce Beacham <bbeacham@no_plm_lowman.co.uk> Date Wed, 20 Sep 2017 22:59:01 +0100 Newsgroups dbase.getting-started 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. Bruce Beacham