Subject Re: Visual FoxPro 7.0 conversion to dBase plus 11 From Ken Mayer <dbase@nospam.goldenstag.net> Date Mon, 16 Jan 2017 07:18:57 -0800 Newsgroups dbase.getting-started On 1/16/2017 5:41 AM, Akshat Kapoor wrote: > One important factor that has to be considered while creating tables. > In foxpro there is no option of default value. All numeric values have a default value of 0 > logical have a default value of false. > > in Dbase the default value has to be specified. > So when a record is appended a logical field will have a value of null. > so if you check the field for true or false both the conditions will be false > ?logical_field = true > ?logical_field= false > > both the above conditions will be false. > So at the time of creation of tables specify a default value according to the field type. Or: set autonullfields off It's a bit easier. You can also do this with the rowset object's autoNullFields property: form.rowset.autoNullFields := false for example. 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