Re: [FB-Tracker] Commented: (CORE-3441) Problem upgrade to FIREBIRD 2.5 (from 2.1)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: [FB-Tracker] Commented: (CORE-3441) Problem upgrade to FIREBIRD 2.5 (from 2.1)

pfg 7gsoft
it's ok
 thank you for your prompt response
 and have a nice day

Pierre François GAIE
7G SOFT

-----Message d'origine-----
De : Dmitry Yemanov (JIRA) [mailto:[hidden email]]
Envoyé : mercredi 13 avril 2011 15:29
À : [hidden email]
Objet : [FB-Tracker] Commented: (CORE-3441) Problem upgrade to FIREBIRD 2.5 (from 2.1)


    [ http://tracker.firebirdsql.org/browse/CORE-3441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23241#action_23241 ]

Dmitry Yemanov commented on CORE-3441:
--------------------------------------

Read firebird.conf regarding the parameter OldSetClauseSemantics.

> 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

       


------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Firebird-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-test