I have also tried to completely rename the tables and fields by adding
a 1 to each name that still does not work. This leads me to
conclude that somewhere there is a serious error in my database.

For the time being I am going to recreate my database and pump
the data over while it still works. I would still appreciate
comments suggestions as to how to prevent/fix this.

Thanks
Gerhardus

Gerhardus Geldenhuis wrote:

> 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/>.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/