[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