[Babase] Possible Babase mistake (Biograph table)

kfenn kfenn at princeton.edu
Wed Dec 10 09:49:55 EST 2008


Susan et al.,

I emailed Catherine yesterday about this briefly and another issue, but 
I looked at it more closely this morning.

DIC1 and WIR3 were the only two I found with a blank rather than a NULL 
name.  This does not affect queries per se... Babase treats NULLS as 
blanks and when you query for nulls or even just sort by name , you see 
the text output with all the NULLS as blank spaces (WIR3 and DIC1 are 
put in with the nulls).  However, I put the nulls in to make it look 
nice when you are browsing the table.

I frequently upload pregnancies as individual files when two pregnancies 
occur in the same update period and I'm constrained by the pregnancy, 
mtd_cycle validations of chronology.  These two were input in that way 
during the first update I did in Babase 2.0 and I probably didn't 
specify the 'null' in the upload program.


Tabby

Susan Alberts wrote:
> Lacey and Tabby, is this on your list of things to fix?
> Thanks,
> Susan
>
> On 5 Dec 2008, at 12:20, Catherine Markham wrote:
>
>> Hi Lacey and Tabby,
>>
>> I noticed that there are (at least) 2 pids in Biograph who have a 
>> null sname but not a null name (there name is simply blank).  Both 
>> appear to be abortions (birth date = death date and sex unknown).  
>> I'm guessing there name should be null and not blank?  That seems 
>> consistent with other records, but I could certainly missing 
>> something obvious.
>>
>> Anyway, the 2 pids that came up in my query are DIC1 and WIR3.  I 
>> haven't searched for others.
>>
>> Catherine
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>
> -------------------------------------------------------------------
> Susan Alberts, Department of Biology, Duke University, Box 90338, 
> Durham NC 27708 USA,  Phone 919-660-7272, FAX 919-660-7293, 
> alberts at duke.edu
>
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

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



More information about the Babase mailing list