[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