On Friday 02 November 2007 20:15:11 Winston Martin wrote:
> The connection to the data source could not be established. error in script
> file line: 32 Constraint already exists: SYS_FK_211 in statement [ALTER
> TABLE "Symptoms" ADD CONSTRAINT SYS_FK_211 FOREIGNKEY ("UniqueOPId")
> REFERENCES "Referral details" ("ReferralID")]
>
Hello Winston,
The error is reporting an inconsistency with the database structure only. Not
an inconsistency with any of your data, which will be fine when you finish
the process of fixing the file.
You can look at this entry at oooOfurm where someone repaired the same FK
failed error.
http://www.oooforum.org/forum/viewtopic.phtml?p=95779#95779
In his case it was a different cause then what is yours, I suppose. But the
basic instructions for the repair are the same.
So follow the steps in the referenece above up to getting the script file
opened, Then in your case simply remove the entire line 32.
Follow the remaining steps.
You can use the Relation function in Base to put the FK relation back if need
be, later.
I HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
