[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