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]
