Updates with Delta values

From: Bruno René Santos (brunoren..olos.pt)
Date: Tue Nov 23 2010 - 17:19:46 UTC

  • Next message: Mike Kienenberger: "Re: Updates with Delta values"

    Hello all,

     

    I doing an update on a hierarchical structures with total values. In order not
    to do locks on the fields I wanted to update these values like this:

     

    UPDATE INFO SET TOTAL = TOTAL + 500

     

    Where 500 is the value the total will be increased with. This way I can have
    several people updating totals concurrently without problems. My question is how
    can I put this kind of structure on a object that is called during the
    commitChanges phase? Is it even possible?

     

    Thanx & Regards

    Bruno Santos

     

    -- 
    

    Bruno René Santos | Gestor de Projectos - Project Manager | <mailto:brunoren..olos.pt> brunorene@holos.pt | <http://www.holos.pt> http://www.holos.pt

    Holos - Soluções Avançadas em Tecnologias de Informação S.A.

    Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan Parque

    Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica

    Phone: +351 210 438 686 . Fax: +351 210 438 687

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify Bruno René Santos by telephone on +351 210 438 686



    This archive was generated by hypermail 2.0.0 : Tue Nov 23 2010 - 17:20:18 UTC