[Babase] Blanks in Neighbors tables
Karl O. Pinc
kop at meme.com
Wed Dec 7 13:25:39 EST 2005
On 12/07/2005 11:19:14 AM, Leah Gerber wrote:
> Hello Karl,
>
> While working on conversion errors I noticed a small issue with the
> neighbors tables. There are a few rows in FPNEIGHORS and JPNEIGHBORS
> that have no neighbor associated with the row. There is a blank in
> both the Sname column and the unkid column. I think that these rows
> should be deleted.
Makes sense to me. Either that or fixed somehow.
I wanted to check to see if deleting these makes
> sense and also see if there is a rule in BABASE about this particular
> situation.
There's _supposed_ to be a rule.
The documentation says "One and only one of these columns
> may contain a value, the other column must then contain NULL." but
> does not address the situation of both being NULL. Maybe we want a
> rule that does not allow both columns to simultaneously be blank.
> There are approximately 10 rows where this occurs.
Yes. I just changed "may" to "must" in that sentence.
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