On 23-6-2015 14:36, 'Thomas Steinmaurer' [email protected] [firebird-support] wrote: >> 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) ... >> or >> 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. > > You may check out the "OldSetClauseSemantics" legacy configuration option in > firebird.conf. Mind the note in the release notes that this configuration > option might be removed in future releases.
It is certain: in Firebird 3 OldSetClauseSemantics has been removed. Mark -- Mark Rotteveel
