[Babase] Re: Hook's female question

Karl O. Pinc kop at meme.com
Wed May 9 10:56:02 EDT 2007


On 05/09/2007 09:35:09 AM, kfenn wrote:
> If Scott is using the online system, Tatu does have a bstatus of 0.   
> She has no bstatus is the Babase1.0 (FoxPro ).  In fact, there are a  
> number of empty bstatus values in Babase 1.0 but there are no empty  
> (null) bstatus values in Babase 2.0.  As I recall, all empty fields  
> in FoxPro are interpreted to be 0 value so they probably converted to  
> real 0's rather than converting to Null values in Babase 2.0.

Yes.  Foxpro can't tell the difference and so they convert to the
same value.

> Jeanne, Susan, were these empty values entered in Babase 1.0 with the  
> intention of indicating 'Null' (no information at all?), or did you  
> want bstatus to never be Null?

IIRC the data entry on the foxpro side, with respect to all "blank"
vs 0 values in all columns, did not consistently use either 0 or
the blank space.

(I don't think there's a good reason to allow Bstatus to be NULL.
If you need another BSTATUSES that means "dunno" then make one
and use that code.)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list