[Babase] [Fwd: Re: OFR error 9 feb]

Karl O. Pinc kop at meme.com
Wed Dec 10 12:48:09 EST 2008


On 12/10/2008 09:09:32 AM, kfenn wrote:
> Lacey Maryott wrote:
>> Hey Tabby,
>> 
>>  I'm sending this to the babase list because I'm honestly not sure  
>> if it can just be deleted.  I'm assuming it can.   Karl, is there a  
>> validation rule that is creating this error? Make sense that there  
>> would be.  If I can get the all clear from the powers that be  
>> (Susan, Karl, Jeanne if you are following this) I will go ahead and  
>> just delete these since I know there is no data other than that she  
>> was out of sight.
>> 
>> Lacey
>> 
> *The specific error message was:
> SQL error:*ERROR:  OFR: BIOGRAPH.Statdate cannot be less than  
> SAMPLES.Date
> 
> I need to update ORF's deathdate to be 2008-04-08 but she has a row  
> in SAMPLES for 2008-04-09.  The sample data has no behavioral data in  
> it as she was not present.

We need to decide if it's ok to put in SAMPLES for somebody when
they are dead, so long as they're then always out of sight.
If so I can change the rules.

Alternately, delete the SAMPLES.  Then you'll be able to
change the date of death.


> 
> 
> Tabby
> 
>-- 
> Tabby Fenn
> Research Assistant
> 
> Dept of Ecology and Evolutionary Biology
> 401 Guyot Hall
> Princeton University
> Princeton, NJ  08544
> 
> 609 258-6898 (Ph)
> 609 258-2712 (Fx)
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 

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