Hi
I have the following script.
drop table "BILLOFMATERIAL";
drop table "WORKSORDER";
commit;

CREATE TABLE "BILLOFMATERIAL"
(
"WONO" INTEGER NOT NULL,
"BMNO" INTEGER NOT NULL,
"LINKTYPE" "DOM_TYPE" ,
"LINKNO" INTEGER,
"COSTPRICE" "DOM_MONEY" ,
"RETAILPRICE" "DOM_MONEY" ,
"ADDINFO" "DOM_MEMO" ,
"QUANTITY" DOUBLE PRECISION,
CONSTRAINT "PK_BILLOFMATERIAL" PRIMARY KEY ("WONO", "BMNO")
);

CREATE TABLE "WORKSORDER"
(
"WONO" INTEGER NOT NULL,
"DESC" "DOM_DESCRIPTION" ,
"IMAGE" "DOM_PICTURE" ,
"QUANTITY" DOUBLE PRECISION,
CONSTRAINT "PK_WORKSORDER" PRIMARY KEY ("WONO")
);

commit;
ALTER TABLE "BILLOFMATERIAL" ADD CONSTRAINT "FK_BILLOFMATERIAL"
FOREIGN KEY ("WONO") REFERENCES "WORKSORDER"
("WONO")
ON DELETE NO ACTION
ON UPDATE NO ACTION
;


the problem with the script is that the moment when i
try to commit the last part the foreign key i get a error that
the object is in use . "ISC ERROR MESSAGE: unsuccesful metadata update
object WORKSORDER is in use"

I have tried deleting the two relevant tables and the sweeping and
restarting the database but to no avail.
Why is this happening and how do I fix this. I suspect there is a value
that remains in the system tables but I can't find it.

Thanks

Gerhardus Geldenhuis