I have tried it with IB-Console and with Interbase Workbench.
I have also tried renaming my key field in the worksorder db as well
as worksorder to works_order but it still does not work.

To create the tables I use Interbase Workbench

Helen Borrie wrote:

> 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
> _______________________________________________________
>
> Yahoo! Groups Sponsor
> [Classmates.com]
> Click here for Classmates.com
> <http://rd.yahoo.com/M=163100.1330039.2920210.2/D=egroupmail/S=1700007709:N/A=524804/*http://www.classmates.com/index.tf?s=2629>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.