We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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
The text was updated successfully, but these errors were encountered:
Commented by: @dyemanov
Read firebird.conf regarding the parameter OldSetClauseSemantics.
Sorry, something went wrong.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Won't Fix [ 2 ]
status: Resolved [ 5 ] => Closed [ 6 ]
No branches or pull requests
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
The text was updated successfully, but these errors were encountered: