Subject Re: null value From Ken Mayer <dbase@nospam.goldenstag.net> Date Thu, 16 Jun 2022 13:10:23 -0700 Newsgroups dbase.getting-started On 6/16/2022 12:59 PM, Mustansir Ghor wrote: > Dear All > > I am saving a null value by following commands but it does not work. > > form.qfoot.rowset.fields["name"].value=null > form.qfoot.rowset.save() > > Is there other way of doing this. Just created a simple table with four fields, first is character, second is numeric, third is logical, fourth is date: q = new query( "select * from testnull" ) q.rowset.beginAppend() q.rowset.fields["Test1"].value := null q.rowset.fields["Test2"].value := null q.rowset.fields["Test3"].value := null q.rowset.fields["Test4"].value := null q.rowset.save() ? q.rowset.fields["Test1"].value == null ? q.rowset.fields["Test2"].value == null ? q.rowset.fields["Test3"].value == null ? q.rowset.fields["Test4"].value == null Seems to work to me. 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 dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm