Joel I've been there and done this. I make sure to set null -0- before loading or unloading data, forms or reports. One way to fix it without unloading and loading everything back is to Update table SET columnname = NULL where columname = '-0-' Buddy
-----Original Message-----
From: Albert Berry [mailto:[EMAIL PROTECTED]
Sent: Fri 8/6/2004 6:13 PM
To: RBG7-L Mailing List
Cc:
Subject: [RBG7-L] - Re: Null character
No, you are not crazy. I suspect that the null setting in the importing
database was set to blank when these records were appended, and R:Base interpreted the
-0- as a text string while importing.
This can happen when the null setting for export to a csv is not the null
setting in the database when the file is imported.
Joel Solomon <[EMAIL PROTECTED]> wrote:
I know its late on Friday, but this is really got me stumped.
I have data that looks like a null (-0-) but does not act like a null.
In some of my fields the null appears and when I set null to a blank
the field is blank (works correctly). But, in other fields the field has a -0- that
does not act as a null. It left justifies itself and is recognizable as a null.
The only difference is that the data with the funny null came from a
laptop computer and the data was later appended to the master table. Both were
entered into a form.
Am I going crazy??
Joel Solomon
Controller
Barbizon International
[EMAIL PROTECTED]
Ph: 954-345-4140 ext. 203
Fax: 954-345-8055
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
<<winmail.dat>>
