[Babase] Rankdate Changes in Babase
Niki Learn
nlearn at princeton.edu
Mon Mar 22 16:23:46 EDT 2010
Babase already says his matured date is 1997-05-01.? How did this even
throw an error about MCE's when BOZ doesn't have a rnkdate? Shouldn't it
ignore males where there is no rnkdate?? And females and juveniles for that
matter since they don't have rnkdates. Karl does this SQL update statement
do if there's no rnkdate?
I started by rolling back the maturedates table, and just did everyone. I
didn't restrict to animals who had anything BUT the first. So it caught him
by chance. This update had nothing to do with rnkdate, i was just using a
function that rolls back the dates that happens to be called rnkdate, on the
maturedates table.
Oh, right. I see. Sorry - my bad. Male and females are in the same table
though. And we're only rolling back male maturedates, yes? I don't see
anything in the SQL provided to account for that. Is there something else
not pasted in here?
So two mounts in March 1996. Males are not supposed to get mounts recorded
until they are mature either, right?
As for how it got in.wouldn't this data have been entered in FoxPro and
converted to Babase, presumably without full Babase controls in place?
Maybe there wasn't a rule to keep it from being entered into FoxPro? If
that's the case then maybe we just need to delete the erroneous mounts, yes?
And fix the error message. ha ha ha.
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Lacey Maryott
Roerish
Sent: Monday, March 22, 2010 3:39 PM
To: The Baboon Database Project
Subject: Re: [Babase] Rankdate Changes in Babase
I have now run into an even stranger error, which I think we should try to
integrate into a conference call. It looks like babase has a rule that MCE's
cannot occur before a male has reached testicular enlargment. So, when I
tried to move the dates, BOZ threw an error.
update maturedates
set matured = rnkdate(matured);
SQL error:
ERROR: BOZ: 1997-05-01: Female's mounts, consortships, and ejaculations
must not come before the maturity date
In statement:
update maturedates
set matured = rnkdate(matured);
Lines 1-2: ERROR: BOZ: 1997-05-01: Female's mounts, consortships, and
ejaculations must not come before the maturity date
At first I thought this was an issue with the function, since the function
is named rnkdate and we are messing with maturedates table. However, BOZ
doesn't even have a rankdate. He matured in May 1997, has NO MCE in 1997. I
looked back and he does have some M records in 1996. So, it seems like what
we are really catching here is the fact that someone data was forced into
babase and this particular error was missed later on.
I'm also not sure why the error message is alerting us to a problem with
females havng these lines when BOZ is a male.
Anyway, I think we did uncover another error and I think it merits some
discussion. I Am going to proceed to work on the update until we can all
talk about this.
It looks like we already need to reschedule Thursday's as Susan's schedule
has a conflict...
Let me know what you think
Lacey
--
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100322/28e4686c/attachment.html
More information about the Babase
mailing list