[firebird-support] RE: unsubscribe

unsubscribe Regards, Hardware Refresh Team From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 04 April 2016 07:42 To: firebird-support@yahoogroups.com Subject: [firebird-support] db corruption Hi everyone. Due to some failing hardware and my tardiness to m

Re: [firebird-support] db corruption

On Mon, Apr 4, 2016 at 2:41 AM, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support] wrote: ... > > > I am using WI-V2.5.3.26780 Firebird 2.5 ODS 11.2 > > ... > > For both databases while running gbak: > > gbak -user sysdba -password masterkey -b -ig -l corrupt.fdb corruptbak.fbk > –v > >

Re: [firebird-support] How to add previous column value to current value?

Try this: select t.name, t.data, coalesce(t.data -(select data from t1 d where d.id = t.id -1),0) from t1 t -- regards, Michał Kurczabiński

Re: [firebird-support] db corruption

Try this: gfix.exe" -mend -full -ignore -user sysdba -pass masterkey "your_corrupted_db.fdb" -- regards, Michał Kurczabiński

ODP: Re: [firebird-support] How to add previous column value to current value?

I can't. sql is generated dynamicly Wysłano ze smartfonu Sony Xperia™ Użytkownik Michal Kurczabinski michk...@gmail.com [firebird-support] napisał >  > >Try this: > >select t.name, t.data, coalesce(t.data -(select data from t1 d where d.id = >t.id -1),0) from t1 t > >-- >regards,

RE: [firebird-support] db corruption

Thanks for the tip Michal, same error: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375) Andrew Zenz From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, 4 April 20

RE: [firebird-support] db corruption

Thanks for the tip Ann. I had a look at the FirstAID tools and tried to use those in conjunction with DBWorkbench but with limited success. FYI FirstAID scanned the database and identified 2 tables as having corruption. I attempted a data pump with DBW excluding those 2 tables but it faile