Re: Re: Error trying to update database - OT

Reizinger Zoltán <[email protected]> Fri, 28 Jan 2011 19:59:24 +0100
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
OOo 3.3 released:
http://www.openoffice.org/index.html
2011.01.28. 19:54 keltezéssel, Dick Hoffman írta:
> Reizinger Zoltán wrote:
>> Upgrade to OOo 3.3
>> Zoltan
>> 2011.01.27. 21:49 keltezéssel, Dick Hoffman írta:
>>> I'm getting an error when trying to add records to a database that I
>>> built some time ago using a form I built some time ago. The error
>>> message says:
>>> Integrity constraint violation - no parent SYS_FK_123 table:
>>> YearStats in statement {INSERT INTO "CBC_DATA_RECS" ("COUNT_YR",
>>> "PREV_REC_NO", "SPEC_NO", "SPECIES_COUNT) VALUES (?,?,?,?)]
>>> SQL status: 23000
>>> Error code: -177
>>> I used this same form about a year ago to successfully update (add
>>> records to) the database. Only major change since then has been an
>>> upgrade to OOo 3.2.1. Any help would be appreciated.
>>> Dick
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>>>
> My understanding of OOo 3.3 is that it's still in RC status, not yet 
> available as a full release. I'll stay with 3.2 for the time being. 
> The problem I had was my doing, not OOo's - see my previous post.
> Dick
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>