[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