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