[Babase] New conversion error (Jeanne?)

Karl O. Pinc kop at meme.com
Tue May 29 23:44:16 EDT 2007


Running _v20 I still get the error:

psql:<stdin>:30: ERROR:  ORI2: Ongoing pregnancy (NULL Resume) has  
subsequent CYCPOINTS (and no intervening gap in observation)
psql:<stdin>:84: ERROR:  insert or update on table "biograph" violates  
foreign key constraint "Pid on PREGS"
DETAIL:  Key (pid)=(ORI2) is not present in table "pregs".


This needs a fake cycgap to go in.

On 05/29/2007 08:40:08 AM, kfenn wrote:
>  ORI2 was born Nov 11, not Dec.  She resumed cycling Nov 20 (tdate)  
> and did in fact have a ddate of 2006-12-13.

The trouble is, the foxpro data says ORI2 was born
on Nov 7, 2007, not Nov 11, 2007.

I'm going to assume that your email has a typeo, not
the database, and go ahead and put in a fake
cycgap for the ORI2 pregnancy and run the conversion
again.  The results will be in _v21.


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