Subject Re: Table level From Mervyn Bick <invalid@invalid.invald> Date Sun, 30 Sep 2018 06:55:04 +0200 Newsgroups dbase.getting-started On 2018-09-30 6:26 AM, Ken Mayer wrote: > set autonullfields should affect everything, not just XDML. This is a > global command, and affects OODML as well as XDML. The nice feature with > this is you can use: > > set autonullfields off > > And then for a rowset where you want nulls: > > rMyRowset.autoNullFields := true > > And it will override, for just that one rowset, the global setting. While we're talking of autonullfields, setting AUTONULLFIELDS OFF does not affect date and timestamp fields.  These fields still contain null values if they are left blank when a record is appended. This is covered in the help file by omission rather than specifically. The help file specifically says what happens with character, numeric and logical fields and ignores the other field types. Memo, OLE and Binary fields are never set to null when a record is appended irrespective of the setting of AUTONULLFIELDS. Autoinc fields can, of course, never contain null. Mervyn.