Subject Re: Table level From Ken Mayer <dbase@nospam.goldenstag.net> Date Sat, 29 Sep 2018 21:26:41 -0700 Newsgroups dbase.getting-started On 9/29/2018 7:48 AM, Akshat Kapoor wrote: >> >> set autonullfields off >> >> Set this in your startup code for your application, and for new records: >> >> logical fields will default to false >> dates and character fields will simply be empty >> numbers will be zero > > I prefer to use both set autonullfields and autonullfields property of > the rowset. > Because we switch from xdml to oodml without thinking as per our needs. 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. 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