I am appending to level 7 table using dbase plus demo. I dont want to make a
ny difference between empty and null fields. I tried using SET AUTONULLFIELD
S OFF, however this did noting , and null fields still remained after append
ing or adding rows. Could someone help me pls ...10q

[ Post a follow-up to this message ]

leander wrote:
> I am appending to level 7 table using dbase plus demo. I dont want to
> make any difference between empty and null fields. I tried using SET
> AUTONULLFIELDS OFF, however this did noting , and null fields still
> remained after appending or adding rows. Could someone help me pls
> ..10q

You need to show us the code you're using ...

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

[ Post a follow-up to this message ]

Ken Mayer [dBVIPS] wrote
>
> You need to show us the code you're using ...
------
Hi Ken,

try the code below...

Roland


// Test: Bug with SET AUTONULLFIELDS?
clear
cAutonull = set("autonullfields")

SET AUTONULLFIELDS OFF

set database to; close tables
if _app.databases[1].tableExists("autonulltest")
_app.databases[1].dropTable("autonulltest")
endif

create table autonulltest (ID char(3), Name char(10))

insert into autonulltest (ID) values ('001')
insert into autonulltest (ID) values ('002')

use autonulltest excl
copy to autonulltest deli
set safety off
zap
set safety on

? "AUTONULLFIELDS is", set("autonullfields")
append from autonulltest deli

go top
if name = NULL
? "Bug: Table contains NULL value"
else
? "OK"
endif

close tables

SET AUTONULLFIELDS &cAutonull

[ Post a follow-up to this message ]

Roland Wingerter wrote:
> Ken Mayer [dBVIPS] wrote
> 
>
> ------
> Hi Ken,
>
> try the code below...

I have the impression this may have been reported as a bug previously.
If not, wanna post it? <g>

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

[ Post a follow-up to this message ]

Ken Mayer [dBVIPS] wrote
>
> I have the impression this may have been reported as a bug previously. If
> not, wanna post it? <g>
-------
I have posted it, just in case...

Thanks

Roland

[ Post a follow-up to this message ]

"leander" wrote
>
> I am appending to level 7 table using dbase plus demo. I dont want to
> make any difference between empty and null fields. I tried using SET
> AUTONULLFIELDS OFF, however this did noting , and null fields still
> remained after appending or adding rows.
------
I reported this as a bug. Till it gets fixed you have several options:
- check out KILLNULL.EXE at http://www.dbase-tools.de/ (in German)
- write your own code
- live with NULLS

Roland

[ Post a follow-up to this message ]

Roland W. schrieb
> Till it gets fixed you have several options:
------
You could also change the table level in the BDE to level 5. Level 5 has no
nulls but also lacks Autoincrement fields and some other features.

Roland

[ Post a follow-up to this message ]

Hi Roland
What does exactly KILLNULL.EXE ? Is it a patch that will automatically act o
n dbase tables level 7 or on db+ itlself ? Or what else ?
Dom

Roland Wingerter Wrote:

> "leander" wrote 
> ------
> I reported this as a bug. Till it gets fixed you have several options:
> - check out KILLNULL.EXE at http://www.dbase-tools.de/ (in German)
> - write your own code
> - live with NULLS
>
> Roland
>
>

[ Post a follow-up to this message ]