[Babase] sexskins upload errors_no mdates

Karl O. Pinc kop at meme.com
Tue May 13 12:55:28 EDT 2008


On 05/13/2008 09:18:38 AM, kfenn wrote:
> Karl O. Pinc wrote:
>> 
>> On 05/12/2008 02:44:55 PM, Karl O. Pinc wrote:
>> 
>>  The solution in the case of
>>> pregnancies is to use the birthdate in place of the Mdate,
>>> anything before the birthdate gets assigned to the conception
>>> sexual cycle.  Events on or after the birthdate get assigned to
>>> the resumption sexual cycle.
>>> 
>>> Should be fixed.
>>> 
>>> Tabby, please review and test.
>> 
>> (As part of the test please double check that it really _does_
>> assign the sexual cycle we think it should when there's
>> a pregnancy.  If you wanted to go wild you could do all the
>> cases: before, on, after the birthdate; gap, no gap, etc.
>> :-P
>> )
>> 
> Karl:  Do I need to run the Update statement first.  What did you  
> recommend using just to get the recalculation done? My notes aren't  
> good but they look like:
> 
> Update sexskins set cid = cid


That will work fine.  I had thought to add a WHERE clause
to just update those that need updating, but there's no
particular reason to do that.  Then you can check what
the automatic assignment did, everywhere, and see that
it's right.

It does not matter if you do the above update statement
first, and fix the existing data, or test first by
inserting new data.

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