[Babase] Blanks in Neighbors tables

Leah Gerber lgerber at duke.edu
Wed Dec 7 12:19:14 EST 2005


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. 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. 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.

Thanks,
Leah


More information about the Babase mailing list