My excuse for the wrong posting.
:)
Gerhardus
Geldenhuis

Helen Borrie wrote:

> This question is off-topic for this list.
>
> Here is the preamble from the membership page of the IBDI list:
>
> "The purpose of this list is to unite InterBase developers under the flag of the Interbase Developer Initiative, a merging of groups dedicated to ensuring that developers and, through them, their customers, will have a controlling interest in the future development of Interbase under open source. It is from the membership of this list that tactics will be effected to arm us with the best possible information on which to base our proposals.
>
> All are welcome aboard who share this common objective and who are willing to give time and effort to it.
>
> For technical support, please subscribe to one of the following lists:
>
> ib-support-subscribe@yahoogroups.com (on this server)
>
> or
>
> interbase@... - go to http://www.mers.com to subscribe."
>
> Thanks for your cooperation.
>
> Helen
> (Moderator)
>
> At 04:47 PM 21-02-01 +0200, 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.
>>
>> Thanks
>>
>> Gerhardus Geldenhuis
>>
>>
>> Community email addresses:
>> Post message: IBDI@onelist.com
>> Subscribe: IBDI-subscribe@onelist.com
>> Unsubscribe: IBDI-unsubscribe@onelist.com
>> List owner: IBDI-owner@onelist.com
>>
>> Shortcut URL to this page:
>> http://www.onelist.com/community/IBDI
>>
>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/