[Babase] Stop times in Actor_actees

Lacey Maryott Roerish lkm9 at duke.edu
Wed Jun 30 14:53:29 EDT 2010


Karl,

    I started trying to upload these and got this error:
*ERROR: INTERACT 829479: DS: 2009-08-11: 11:11:28: 11:11:28: Agonism and
grooming start and stop times must be NULL when there's no Sid*
*
*
I can see why we would have set up this control.. but what do we do now?
Susan, any input?

Cheers
Lacey

On Tue, Jun 29, 2010 at 8:39 PM, Karl O. Pinc <kop at meme.com> wrote:

> On 06/29/2010 07:32:40 PM, Karl O. Pinc wrote:
> > On 06/29/2010 05:23:46 PM, Lacey Maryott Roerish wrote:
> > > The files I will be uploading have the following columns:
> > > date, actor, actee, act, start
> > >
> > > Should I add a stop column and just leave it blank?
> >
> > My approach would be to add and stop column and copy (by
> > cell reference) the start column into it so they're always
> > the same.  But I'd also want to at least consult with Susan.
>
> Ok.  I was looking in the wrong place.  If you look
> at the "initial description" of the INTERACT_DATA table
> you will see all the rules that have to do with more than
> one column or with relationships to other tables.  In there
> it says that the start time must equal the stop time.
>
> So, that's what we should do.
>
> But, you'll have to do this manually per above.  The
> view won't do it for you.
>
>
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                 -- Robert A. Heinlein
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>



-- 
- -
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/20100630/e2fb0774/attachment.html


More information about the Babase mailing list