srotyliano@... [firebird-support] schrieb am 23.06.2015 14:31:

> 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.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.