At 07:07 PM 03-07-02 +0100, you wrote:

>Hi,
>
>The code posted in the email at the bottom of this email doesn't work to
>create a foreign key.
>
>I receive the error:
>
>Unsuccessful metadata update
>could not find UNIQUE INDEX with specified columns
>Statement: CREATE TABLE RELATEDSUBJECT (
> RELATED_SUBJECT_ID INTEGER NOT NULL,
> DEWEY_NO_ID INTEGER NOT NULL CONSTRAINT FK_DEWEY REFERENCES DEWEYNO(ID),
> RELATED_DEWEY_NO_ID INTEGER NOT NULL,
> PRIMARY KEY (RELATED_SUBJECT_ID)
>)

It means that ID is not the primary key of DEWEYNO; or that ID does not
have the UNIQUE constraint applied to it.

Have you managed to get your hands on the documentation yet? Try this link:

ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip

heLen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________