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]
