[Babase] Agonism Grooming Issue Update

Lacey Maryott lacey.maryott at duke.edu
Wed Mar 28 09:10:36 EDT 2007


Backing up the database is kind of uncharted territory for me.  Are we 
talking put it on a disc, put it in another location and work with that, 
or is there some sophisticated way to back stuff up?  Leah copied all 
the babase dbf files from foxpro into my documents so i could play with 
SQL a bit and not mess anything up.  I could try it there first?  Let me 
know what you think! Thanks so mush

Lacey

Karl O. Pinc wrote:
>
> On 03/27/2007 02:08:38 PM, Lacey Maryott wrote:
>
>>  This will include any data which do
>> not currently fall on the first being moved to the first, so that 
>> there should be no data existing on any day but the 1st of each month 
>> for all years before 1995.
>
> The update statement for this is:
>
> UPDATE interact ;
>   SET date = CTOD("1/" + MONTH(date) + "/" + YEAR(date)) ;
>   WHERE DAY(date) != 1 ;
>         AND (act = "A" OR act = "AS" OR act = "OS" OR act = "DS") ;
>         AND YEAR(date) < 1995
>
> (At least I think that'd be right.  My foxpro is rusty.)
>
> Be very sure to backup the database before messing
> around with this.
>
> 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 Maryott
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list