Hello ,

For this time , there is from one to three or four corrupted bases a
week , it's true that it is also mostly the same tables ( there are 3
recurrent case ) , but a problem is that the database has not the exact
same structure in each client and the repair scripts may sometime not
working fine , the most difficult part of the process is to copy data
from reference and be sure to update all tables that used a primary key
from one old record ( corrupted ) as a foreign key and update those with
the new ID .
I have take a look at interbase documentation and some nice blog about
rdb$ tables and I have learn a lot from this but even it's seems not so
difficult to obtain the FK use in a specific table , I can't find how to
list the tables that depends on a specific column from one origin table .
I have to say that origins of corruption are not from Firebird but more
from hardware problems .
regards,

Le 31/07/2012 00:18, Alan McDonald a écrit :

>
> You're implying that you have frequent enough cases of corruption to
> warrant such an effort. Is this true?
> Alan
>
> On Monday, July 30, 2012, harveypekkar wrote:
>
> > Hello ,
> >
> > I am trying to query the system table of firebird ( version 2.1) to
> > obtain the list of table and fields wich use the primary key from
> another
> > as foreign key , the goal is after a database corruption , and after
> having
> > mend the corrupt records , to recopy from a backup with new ID and after
> > updating in others tables using the ID as a reference by the new one ( I
> > hope i'm clear enough !! ) , this part works fine but I want to automize
> > the process a little and in case of a new table corruption , being
> able to
> > list the table that use the primary key as a reference to refresh them .
> > Best regards ,
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org 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
> >
> >
> >
> >
>
> --
> regards
> Alan McDonald
>
> [Non-text portions of this message have been removed]
>
>
> *TODAY*/(Beta) /*.*Powered by Yahoo!
>
> Photos help solve enduring moon mystery
> <http://news.yahoo.com/apollo-moon-landing-flags-still-standing-photos-reveal-212000880.html;_ylc=X3oDMTFnbWRpZmt1BF9TAzk1NDAxMDAyNwRwa2cDaWQtMjQ1MjkwMQRzeWlkA2M4MmEwNGIuamg0MjBkag-->
>
> Get Yahoo Search App!
> <http://search.yahoo.com/mobile/searchapp?p=yahoo_search_app&fr=appsrch&.tsrc=appsrch>*.
> *Privacy Policy
> <http://info.yahoo.com/privacy/us/yahoo/webbeacons/details.html>
>

*TODAY*/(Beta) /*.*Powered by Yahoo!

Olympics reporterâ??s awkward on-air kiss
<http://sports.yahoo.com/blogs/olympics-fourth-place-medal/olympic-spectator-plants-kiss-unsuspecting-television-reporter-video-151712354--oly.html;_ylc=X3oDMTFkN2NuczRrBF9TAzk1NDAxMDAyNwRwa2cDaWQtMjQ1MjU4OARzeWlkAzcwaGw0b2Y0YWEwaA-->

Get Yahoo Search App!
<http://search.yahoo.com/mobile/searchapp?p=yahoo_search_app&fr=appsrch&.tsrc=appsrch>*.
*Privacy Policy
<http://info.yahoo.com/privacy/us/yahoo/webbeacons/details.html>


[Non-text portions of this message have been removed]