Sorry Lucas, I send a image with the error but the server dos not accept.
The error is show above:

- command -
alter table CAIXUSUA
add constraint FK_CAIXUSUA
foreign key (USUA)
references USUA(USUA)
on update CASCADE

- result -
This operation is not defined for system tables.
unsuccessful metadata update.
object USUA is in use .


Thank you!

Lucas Franzen escreveu:

>
>
> Marcello Fontolan schrieb:
>
> > I'm always getting this erros trying create a foreing key.
> > Any help?
>
> Even if the info you supply is very marginal I think the problem is that
> you have several connections to your database established.
> When adding a foreign key constraint you have to have single user access.
>
> If this is the case and you still got propblems you should tell us the
> exact error message and show us the alter table statement you use.
>
> Luc.
>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

--

..::
Marcello Fontolan
marcello@...
::..