I have tried all this I have the only connection in the network
to this db I have restarted, looked for lost transactions, sweeped the
database.
I dont think the script is at error(exept for Helen's comment) the error
is somewhere in the db.

CHeers
Gerhardus

Paul Reeves wrote:

> Gerhardus Geldenhuis wrote:
>
>> 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.
>>
>
>
> Gerhardus,
>
> I ran the following script through ISQL :
>
> drop table "BILLOFMATERIAL";
> drop table "WORKSORDER";
> commit;
>
> CREATE TABLE "BILLOFMATERIAL"
> (
> "WONO" INTEGER NOT NULL,
> "BMNO" INTEGER NOT NULL,
> "QUANTITY" DOUBLE PRECISION,
> CONSTRAINT "PK_BILLOFMATERIAL" PRIMARY KEY ("WONO", "BMNO")
> );
>
> CREATE TABLE "WORKSORDER"
> (
> "WONO" INTEGER NOT NULL,
> "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
> ;
> commit;
>
> I didn't have any problems.
>
> Firebird / InterBase(r) needs exclusive access to make the metadata update, as
> you have probably realised. My guess is that a second connection, or even just a
> second transaction is open.
>
> Try closing all connections to the database. Probably best to stop and restart
> the server to make sure.
>
> Then, connect to the database with ISQL and use INPUT myscript.sql (or whatever
> is relevant for your context.)
>
>
> Paul