[Babase] Agonism Grooming Issue Update

Karl O. Pinc kop at meme.com
Tue Mar 27 15:39:55 EDT 2007


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



More information about the Babase mailing list