If I were you i'd solve the reason for the corruptions and not spend any
time on the correction methods you are trying to make. I have about
500 personal server years under direct management with no corruption since
dropping use of the BDE some many years ago.
I wouldn't be using FB if it were the way you describe.
Alan

On Jul 31, 2012 3:56 PM, "harvey pekkar" <harveypekkar@...> wrote:

> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>


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