Subject Re: [firebird-support] Issues migrating from FB 1.5 to 2.5

Hi Karol,

I think you are right on, I found this which is what I suspect is throwing the error in 2.5 (but not so in 1.5). I might have to go back to my old box running 1.5. 

Do you know if it is possible to convert and downgrade a 2.5 *.fdb file to a 1.5 version ?

Multiple Hits to Same Column Now Illegal

It is no longer allowed to make multiple “hits” on the same column in an INSERT or UPDATE statement. Thus, a statement like

  INSERT INTO T(A, B, A) ...


  UPDATE T SET A = x, B = y, A = z

will be rejected in Firebird 2.n, even though it was tolerated in InterBase and previous Firebird versions.