On 8/30/06, Don Parris <[EMAIL PROTECTED]> wrote:
On 8/30/06, Don Parris <[EMAIL PROTECTED] > wrote:
> On 8/30/06, Frank Schönheit - Sun Microsystems Germany
> < [EMAIL PROTECTED]> wrote:
> >
> > Hi Don,
> >
> > > When I try to establish the relationship as
> > > tlb_A.field1 = tbl_B.field1
> > >
> > > I get the following:
> > >
> > > SQL Status: 23000
> > > Error code: -177
> > >
> > > Integrity constraint violation - no parent 133, table:
> > tbl_Survey2006 in
> > > statement [ALTER TABLE "tbl_Survey2006" ADD FOREIGN KEY ("biz_id")
> > > REFERENCES "tbl_BizContact" ("biz_id")]
> >
> > I assume that in "tbl_Survey2006", you have a record with "biz_id"
> > beeing 133, but "tbl_BizContact" is missing a record with "biz_id"
> > being
> > 133. Thus, a relationship cannot be established, since for this
> > particular survey record, there's no contact record which it refers
> > to.
>
>
>
> Aha! That's what the '133' refers to. I'll look into that. Thanks for
> the input.
>
Well, I found the problem in my Calc sheet, but created a new problem. My
Calc sheet had a few empty rows, where I had intended to add some new
records, but forgot to delete the empty rows when I did the copy/paste
operation. I fixed that, and when I try the copy/paste operation, I create
the table with no errors. However, attempting to open the table causes OOo
to crash. And yes, it's repeatable.
I use Ubuntu Dapper on a Dell Latitued with 256MB RAM. I'm going to
attempt it again at work on a more robust workstation. I'll see what
happens there.
I did manage to successfully use the paste operation to re-create
tbl_BizContact - with all the data intact. The actual number of records is
650. However, when I attempt to re-create tbl_Survey2006, I can only get
315 records into the table successfully, using the paste operation to create
the table. #316 - #360 are dropped. Copying the remaining data from Calc
and using Paste --> Append Data in Base doesn't add even one new record to
the table.
My question now is, how to get the rest of the data into the table quickly?
I am facing a major issue in that, frequently, attempts to copy data in Calc
(for pasting into Base) lead to OpenOffice.org (2.0.3) freezing up on me.
I'll copy the data, and then attempt to switch from the Calc window to the
Base window. Nothing happens, although I can minimize/maximize the Calc
window. With Calc minimized, Base is just a white screen. I can use other
apps as well, though I have tried this without any other apps open. I have
also experienced issues where OOo just shuts down suddenly, and asks if I
want to restart it automatically. These things happen whether using Ubunt
Dapper (1.2GHz/256MB RAM laptop) or Windows (3GHz/504MB RAM workstation).
I'm willing to say it's crashed 20 times today, altogether.
Thanks again,
Don
