--- In firebird-support@yahoogroups.com, "sebastianmartin98"
<sebastian.martin@g...> wrote:

> FOREIGN KEY (DEPORIGEN) REFERENCES DEPOSITOS
> (CODDEPOSITO),
> FOREIGN KEY (DEPDESTINO) REFERENCES DESPOSITOS
> (CODDEPOSITO));
>
> I always receive an error like this:
>
> Statement failed, SQLCODE = -607
>
> unsuccessful metadata update
> -could not find UNIQUE INDEX with specified columns
> Statement failed, SQLCODE = -104
>
> If I only use one reference to the foreing key, it works fine.
> any help?? why is that? is my error?

Sebastian, perhaps typo in table name - is it DEPOSITOS or
DESPOSITOS?

Best regards,
Alexander.