Submitted by: GAIE PF (pfg)

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