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" <harveypek...@yahoo.com> 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]