[Babase] Samples/neighbors error when attempting to censor males

Karl O. Pinc kop at meme.com
Tue Jan 19 16:12:07 EST 2010


On 01/19/2010 01:11:55 PM, Niki Learn wrote:

> ERROR:  DIG: BIOGRAPH.Statdate cannot be less than SAMPLES.Date 
> unless
> NEIGHBORS.Sname individual is alive
> 
> ERROR:  LUI: BIOGRAPH.Statdate cannot be less than SAMPLES.Date 
> unless
> NEIGHBORS.Sname individual is alive

> So I looked these guys up in samples and Luigi didn't even have an
> entry.
> Meanwhile Digit had many entries but his last entry was for 25 Aug
> 2007,
> which matches his last census entry and current statdate.  I am 
> trying
> to
> change his statdate to a censordate of 27 Aug 2007, which is NOT less
> than
> the last samples date.  Neighbors doesn't even have dates.  I'm not
> real
> familiar with how those tables interact so I don't know where else to
> look
> for whatever is causing this error.

The place to look is the social interactions ER diagram on page
10 of the pocket reference.

DIG is a neighbor of DIB as of 2008-10-13, so you can't "stop his
existance" after 27 Aug 2007, which is what setting his Statdate
back would do, when his Status is not 0 (alive).  I presume you're
also changing his Status to 2 (censored).

select samples.date, samples.sname, neighbors.sname, neighbors.ncode
  from samples, point_data, neighbors
  where neighbors.sname = 'DIG' 
        and neighbors.pntid = point_data.pntid 
        and point_data.sid = samples.sid 
  order by samples.date desc, samples.stime desc;   

We could change the rules for Status = 2 (censored) but
I don't think we really want to.  (Right?)

The error message is not the best.  The key indicator
is that it talks about NEIGHBORS.Sname as the problematic
column.  I'd be happy to come up with a better message
but suspect this is a systemic problem.  I'm
(very likely) using the same error message you'd get
if you messed around in the NEIGHBORS table
and have probably written error messages in this
fashion all over the system.  Anyhow, suggestions
are welcome.

I didn't look at LUI but I suspect something similar.
If he's still a problem let me know and please tell
me exactly what it was you were trying to do when
you got the error.  (I know your brain is running
on empty at times these days.)

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