I just examined the imported file. It is a fixed length field file
The offending line is not actually null, but the data is not in the
fields where it should be.
I have fixed the issue, but am surprised that the fields in the DB
didn't show up as null.
Dick Fey
Dick Fey wrote:
Tried that too...
You can do a delete where count = 1, but you can't test for anything
because the nulls do not show up.
Dick
Steve Vellella wrote:
Dick,
Why don't you see if you can look up the blank data using a literal
null in
your where clause (where colname1 = ' ')
Steve Vellella
Office: 520-498-2256
Cell: 520-250-6498
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey
Sent: Thursday, April 22, 2010 12:47 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Unusual Null behavior
Using 7.5
I am importing a table of colors into the database using the Load
command. Four columns, 3 contain data, 1 is empty.
Sometimes a blank row will import.
With Null set to -0-, only the column with no data shows the null in
the blank row.
The columns containing data display a blank field in that row.
You can delete the row manually, but not using a delete command,
because the only field that appears to be null is the column in which
all rows are null. Thus if you use that column to delete on, all rows
are deleted.
Ah the mysteries of life.
How about it genuis's... what is happening?
Dick Fey
Carpet Broker Inc.
