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