[firebird-support] Problem - deleting records from view

2012-10-13 Thread Jacek Borowski
Hi, Firebird 1.5.6 CS tested on Linux and Windows 2008R2. During deletin record from view I got an error: Unsuccessful execution coused by a system error that precludes successful execution of subsequent statements. internal gds consistency check (record length incostistent (178)). Error

[firebird-support] Comparing databases using scripts generated from isql -extract?

2012-10-13 Thread tomsee7
Hi, Does anyone of any tools for comparing databases using scripts generated from the isql -extract command? This seems to be the most convenient way (i.e. comparing scripts) and must be a common need. The ones that I've come across seem to want you to be connected to one or more of the

Re: [firebird-support] Comparing databases using scripts generated from isql -extract?

2012-10-13 Thread Roberto Carlos
Compare to Firebird databases via system tables (rdb$) is basically a bunch of WHILEs and FORs. For compare scripts on Debian Linux, use DIFF: apt-get install diffutils diffutils-doc Study the programs: diff, diff3, sdiff and cmp. Roberto Em 13/10/2012 14:30, tomsee7 tomconl...@gmail.com

[firebird-support] avoiding corruption?

2012-10-13 Thread heineferreira
Hi I am still fairly new to Firebird. Are there any best practices for avoiding Firebird database corruption or minimizing database corruption? I suppose the most obvious one is having a ups on your Firebird server. Thanks H.F.