I think you are 100 % right , the problem is that i am not working in the developpement team but in customer support , I suspect some software update to cause the problem but I have no access on that , the only thing I can do is to try to repair the best way for my client and I can't only validate and mend , I have also to put back the records from a backup with new ID or the problem will not be solve completely .
We have about 500 servers too, the structure is from 2 up to 20 clients , little workgroup under windows XP and 7 .
I don't think the problem concern the firebird side , I know it's very strenght .
thank you for your advice , sorry for my english I'm french :) .
Regards .

--- In firebird-support@yahoogroups.com, Alan McDonald <alan@...> wrote:
>
> 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]
>