At 07:25 AM 22-02-01 +0000, you wrote:

>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.

What tool are you using to run the script?

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________