Subject Re: Table level
From Charlie <tm@tc.com>
Date Sat, 29 Sep 2018 18:16:25 -0400
Newsgroups dbase.getting-started

Thanks everyone.  This is resolved.

Akshat Kapoor Wrote:

> On 29/09/2018 15:52, Charlie wrote:
> > I am almost done with converting all tables in my projects from level 4 to level 7.
> >
> > In level 4 my new numeric fields automatically start with a zero.  I am finding level 7 numeric fields start with null.  That is only a problem if you are doing something like replace XX for field = 0.  I have found one instance of this so far.
> >
> > Does anyone know if any other type fields are affected?  I am having problems with a logical field and haven't checked for this yet.
> >
> > Thanks...
> >
>
> It all depends on who is the manager of the system. If you are the
> person managing the system then open the table in table designer.
>
> In the inspector set the default value to 0 for numeric fields.
>
> Level 7 Tables have the option of null fields. So unless assigned the
> value is null. This is there with all fields.
>
> And it will cause heart burn if you are not prepared for it.
>
> For one time modification of data use the attached prg. You will have to
> change it to point to the correct table
>
> In future use the SET autonullfields or the autonullfields property of
> the rowset to avoid unintended nulls.
>
> As a safety I had started assigning some value or the other to each and
> every field be it 0 space or false.
>
> I hope this helps
> Regards
> Akshat
>