[Babase] Re: new babase

Leah Gerber lgerber at duke.edu
Mon Mar 13 11:28:54 EST 2006



>> Thanks. That cuts out a lot of errors. It almost looks manageable now 
>> :). The following error seems like it might be a coding problem. I 
>> can't figure out what else would be causing the error. The majority 
>> of the errors look like this one.
>>
>> psql:<stdin>:897: ERROR:  insert or update on table "allmiscs" 
>> violates foreign key constraint "Sid on SAMPLES"
>>
>> DETAIL:  Key (sid)=(12662) is not present in table "samples".
>
> Could you double check the data on foxpro for me and be sure
> that the keys in adlibs relate to rows in samples?
>
Karl,

I queried adlibs and samples in Foxpro. Every row in adlibs has a 
corresponding row in samples, without exception. These are related by sid.

Leah




More information about the Babase mailing list