[Babase] UPLOAD pregs error
Karl O. Pinc
kop at meme.com
Thu Jan 3 16:04:11 EST 2008
On 01/03/2008 02:05:53 PM, kfenn wrote:
> Hi again Karl,
>
> FYI, the Upload program won't let me use anything but the birthdates
> for statdates...no super fake dates allowed.
Oh yeah. I think that's even documented for BIOGRAPH.
>
> But that's not my current problem.
>
> I just tried to upload two pregs to the pregs table because they were
> missing and I can't have an infant enter the biograph table unless
> there is a record of a pregnancy.
You _can_ put an infant in to BIOGRAPH, and omit the Pid (make it NULL)
and put it right later once you get a PREGS row in. I don't know if
this is the best course of action, ever, but it's an option.
>
> So, I tried to upload the pregs and got this error message, which I
> could understand if were trying to upload a LYE pid at all, but I'm
> not (its ABB and ACA). Why is this coming up?
What goes in the pregs table are Cpids (CYCPOINTS keys), not
Cids (CYCLES keys). I suspect you put in a Cpid of a CYCPOINTS
that belonged to LYE. If that's not the case then I'll need to
see the data you tried to insert. If it is the case then we
can consider re-arranging the validation so that, e.g., a check
for whether the CYCPOINTS row is a Ddate, comes first so that the error
message might be a bit saner. (Although it's always going to
be odd when the pregnancy belongs to an unexpected female.
There may not be anything to be done.)
>
> ERROR: LYE2: 3: Parity out of sequence: Mismatch with preceeding
> pregnancy
...
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