Subject Re: null value
From Ken Mayer <>
Date Thu, 16 Jun 2022 13:25:18 -0700
Newsgroups dbase.getting-started

On 6/16/2022 1:20 PM, Mustansir Ghor wrote:
> Dear Ken Sir
> I had a field with space values, so i had put the syntax in function to null them. But it remained to have spaces.

Are you sure? How are you checking? Is there something in the table
setup, for example, a MySQL table, where you have a default value of

> Is there a difference between = and := when putting value to a fields?

:= is the assignment operator, and it avoids issues with typos, among
other things ... for example:


Note that I left out the "ue" part of the keyword "value". The statement
above will create a property of the "name" field, called "val".

By using the assignment operator, if "val" doesn't exist, you will get
an error:

form.qfoot.rowset.fields["name"].val := null

It's a useful tool. And since "=" is used to compare values (although in
most cases I use "==" instead), it avoids confusion when looking at the


*Ken Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial:
dBASE Web Tutorial: