Problem upgrade to FIREBIRD 2.5 (from 2.1)
------------------------------------------
Key: CORE-3441
URL: http://tracker.firebirdsql.org/browse/CORE-3441
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Delphi 5 / windows XP pro SP3 / Interbase objects
(ibquery on standard borland VCL)/ FIREBIRD 1.5/2.1/2.5
Reporter: GAIE PF
Priority: Critical
hello,
Firebird 1.5 to 2.1 with this sql query works :
sql.add('UPDATE STOCK SET ');
sql.add(' QTEDEPART=QTEDEPART+ :QTEDEPART');
sql.add(', QTEENTREE=QTEENTREE+ :QTEENTREE');
sql.add(', QTESORTIE=QTESORTIE+ :QTESORTIE');
sql.add(', QTESTOCK=QTEDEPART+QTEENTREE-QTESORTIE ');
but she no longer works on the last line with Firebird 2.5 and you must write
sql.add(', QTESTOCK=QTEDEPART+ :QTEDEPART +QTEENTREE + :QTEENTREE -QTESORTIE
-:QTESORTIE');
but with this line, Firebird 2.1 doubles matches....
this poses a problem when you have many clients already installed. ( upgrade
firebird to 2.5)
Many thank's
Pierre François GAIE
7G SOFT
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Forrester Wave Report - Recovery time is now measured in hours and minutes
not days. Key insights are discussed in the 2010 Forrester Wave Report as
part of an in-depth evaluation of disaster recovery service providers.
Forrester found the best-in-class provider in terms of services and vision.
Read this report now! http://p.sf.net/sfu/ibm-webcastpromo
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
