Hi..
I'm a newbie who has broken his database..
I have a small database with two tables with a relationship between the primary
field ("ID") on one and a similar field on the other. All was working well,
but I think I inadvertently set the "ID" field on the second table to "primary"
as well.
After inputting all the data, everything was fine until I restarted the
database. I now get the following error when trying to open the data source.
SQL Status: S1000
Error code: -78
error in script file line: 4 Constraint already exists: SYS_FK_88 in statement
[CREATE CACHED TABLE "Skills"("SAR Basics" BOOLEAN,"Basics Date"
VARCHAR(50),"FirstAid" BOOLEAN,"FirstAid Expiry" DATE,"Executive"
VARCHAR(50),"Executive Expiry" DATE,"Search Manager" BOOLEAN,"Search Manager
Date" DATE,"Mantracker" BOOLEAN,"Mantracker Date" DATE,"ID" INTEGER NOT
NULL,"Team Leader" BOOLEAN,"Last Search/Mock" DATE,"Team " CHAR(1),CONSTRAINT
SYS_FK_88 PRIMARY KEY("ID"),CONSTRAINT SYS_FK_88 FOREIGN KEY("ID") REFERENCES
"Members"("ID"))]
I cannot open or edit the tables now. Is there a way to edit the individual
lines in the script and recover my work?
Any suggestions would be greatly appreciated. I realize this is 100% my
fault...
Thanks in advance
Bud
