Well, when I find this situations I do:

1. Backup my db in a file .gdk but this don't finish correctly
2. So I Extract Metadata with schema and data in a file (very big file .sql)
3. I try to Execute this and I obtain the line which cause violation of FK
4. I correct with a editor of text
5. I retry di exeute this e all work fine

but myquestion is: why someting I find a db in a error situation (violate e FK)
note the violation is caused form a normal INSERT statemant.


Thanks a lot for your attentions
By
Alberto

> Alberto Pesce wrote:
> >
> > Sometimes I find in my database a incorect situation, like data which violate the FK.
> > Well, in this situation my database don't work fine.
>
> Have you made recent metadata changes? How often does this happen?
> Are there any patterns?
>
> Regards,
>
>
> Ann
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

____________________________________________________________
6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero!
Scaricalo su INTERNET GRATIS 6X http://www.libero.it