Subject Re: FK confusion
Author Ali Gökçen
Pardon,
it was my sunday laziness... references on "Cust"(ID).

...
>
> CREATE UNIQUE INDEX "IDX_Cust_13" ON "Cust" (ID);
>

Did you commited this create index command and was it ok?

>
> ===================== Alter Table doesn't work
> ==================================
> ALTER TABLE "ACCCHEM" ADD CONSTRAINT "Cust_ACCCHEM"
> FOREIGN KEY ("Acc ID") REFERENCES "Cust" (ID) ON DELETE CASCADE
ON
> UPDATE CASCADE;
>
> I get this error message:
>
> This operation is not defined for system tables.Unsuccessful
metadata
> update.
> Could not find UNIQUE INDEX with specified columns.
>
> IDX_Cust_13 is there, though. What am I overlooking?
>
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.
>