I was keeping the project open in the Delphi.
After close, it works fine.

Thank you Lucas for the hint.


Marcello Fontolan escreveu:

> 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@...
> ::..
>
>
>
> ------------------------------------------------------------------------
> *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@...
::..