It means that the fields ID_DISCIPLINA, ID_PARCEIRO has to be primary key
in the table LECIONAR to be able to create a foreign key in the table
DIARIO.

ronaldorezende Escribio :-)

>
>
>
>
> When I try do perform this operation, I have a error. What's wrong?
>
> alter table DIARIO
>    add constraint FK_DIARIO_DISCIPLINA_PROFESSOR foreign key
> (ID_DISCIPLINA,ID_PROFESSOR)
>       references
> LECIONAR(ID_DISCIPLINA,ID_PARCEIRO);
>
>
> Operation Completed - There Were Errors
> ISC ERROR CODE:335544351
>
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> could not find UNIQUE INDEX with specified columns
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Carlos Chávez
AG Software, S.A.
776-8344
267-3007