Hi, Well, I don't think it's a bug, and I don't think they will "fix it".
I suggest that you try it, and then ask BMC if this is as designed. The consistency of this "bug" is thorough, and I have depended heavily on it in an internal RRR-system I built right after 7.6.04 was released. Best Regards - Misi, RRR AB, http://rrr.se > Very happy until reading your last sentence :) > > I can't provide a development based on a "bug". If someday BMC "solves" > it, > then my development will crash. > > Thanks! > > Jose M. Huerta > Project Manager** > > Movil: 661 665 088 > > Telf.: 971 75 03 24**** > > Fax: 971 75 07 94**** > > <http://www.sm2baleares.es/>**** > > SM2 Baleares S.A. > C/Rita Levi **** > > Edificio SM2 Parc Bit**** > > 07121 Palma de Mallorca**** > > <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> > <http://twitter.com/#!/SM2Baleares> > <http://www.linkedin.com/company/sm2-baleares> > > La información contenida en este mensaje de correo electrónico es > confidencial. La misma, es enviada con la intención de que únicamente sea > leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje > por otras personas no está autorizado, por lo que en tal caso, le rogamos > que nos lo comunique por la misma vía, se abstenga de realizar copias del > mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de > inmediato.**** > > P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es > necesario. > > > > On Wed, Jun 13, 2012 at 3:46 PM, Misi Mladoniczky <m...@rrr.se> wrote: > >> Hi, >> >> If you walk your table, and then perform a service-call to the >> details-records one at a time. >> >> Whatever happens inside that service-call (a push-fields to the >> details-record in this case), will be committed to the database before >> the >> service-call exits. >> >> This will then enable you to do a COLSUM(), or some such thing, on your >> details-records after your table-walk has been completed. >> >> The drawback is that the details-updates will be committed to the >> database >> even though a later update should fail with an error... >> >> Another drawback is that Doug Mueller has told me that if it works like >> that, it is a bug, and should be fixed. But I have seen no evidence of >> this being addressed in the 3 service packs released so far... >> >> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) >> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >> logs. >> Find these products, and many free tools and utilities, at >> http://rrr.se. >> >> > Can't use active links. The parameter can be changed from another form >> > using a push and active links won't be triggered. >> > >> > Thanks! >> > >> > El miércoles, 13 de junio de 2012, Joel Sender escribió: >> > >> >> ** >> >> >> >> Jose,**** >> >> >> >> You might try it in stages;**** >> >> >> >> **1. **An active link pushes the new Invoice value to all the >> >> detail entries**** >> >> >> >> **2. **A filter recalculates each detail’s value(s)**** >> >> >> >> **3. **A second active link (higher exec order) recalculates >> (or >> >> triggers filters to recalc) Invoice values from the detail >> entries.**** >> >> >> >> HTH,**** >> >> >> >> *Joel*** >> >> >> >> Joel Sender jdsen...@earthlink.net <javascript:_e({}, 'cvml', >> >> 'jdsen...@earthlink.net');> 310.829.5552**** >> >> >> >> ** ** >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> >> arslist@ARSLIST.ORG <javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG >> ');>] >> >> *On >> >> Behalf Of *Jose Huerta >> >> *Sent:* Monday, June 11, 2012 5:27 AM >> >> *To:* arslist@ARSLIST.ORG <javascript:_e({}, 'cvml', >> >> 'arslist@ARSLIST.ORG');> >> >> *Subject:* Development question**** >> >> >> >> ** ** >> >> >> >> ** Hi listers,**** >> >> >> >> ** ** >> >> >> >> I have a question for developers. I've got a solution, but I want to >> >> know >> >> if there is a better option, since it doesn't satisfy me 100%.**** >> >> >> >> ** ** >> >> >> >> Here's the case (It's not really my case, but a simplified version of >> >> it): >> >> **** >> >> >> >> ** ** >> >> >> >> I have one form: AAA:Invoices.**** >> >> >> >> This form has a table field that shows related requests on >> >> AAA:DetailLines. >> >> **** >> >> >> >> ** ** >> >> >> >> So each invoice in AAA:Invoices is related to several Detail Lines in >> >> AAA:DetailLines.**** >> >> >> >> ** ** >> >> >> >> I have a field in AAA:Invoices that is a parameter used to compute >> the >> >> value of the detail lines. I call it: InvoiceParameter.**** >> >> >> >> I have a filter that when InvoiceParameter is changed, it propagates >> it >> >> to >> >> all related detail lines. When those lines are modified, they >> >> automatically >> >> (with filters) recalculate their value.**** >> >> >> >> ** ** >> >> >> >> I also have a total value field at AAA:Invoices that it is the sum of >> >> the >> >> detail lines. I want to keep it updated, so I thinked some options, >> but >> >> concurrency makes the result going wrong.**** >> >> >> >> ** ** >> >> >> >> Summarizing the case: The objective is that when modifying the field >> >> InvoiceParameter at an Invoice, it propagates to the detail lines, >> >> recalculating its value, and returns to the invoice with the total as >> >> the >> >> sum of all detail lines.**** >> >> >> >> ** ** >> >> >> >> If I do it with a filter, the contents of the table at AAA:Invoice is >> >> not >> >> updated until the end of the transaction. So I can't see the new >> values. >> >> And If I use parameter sending, only one of the detail lines, do >> >> actually >> >> change the value, the rest are lost, (beacuse concurrency).**** >> >> >> >> ** ** >> >> >> >> Using the override phase at PUSH actions, it overrides the ARS >> action, >> >> but >> >> not the SQL sending, that is sent at the end.**** >> >> >> >> ** ** >> >> >> >> ** ** >> >> >> >> My solution is to have a filter at AAA:Invoice that propagates the >> >> InvoiceParameter to the detail lines. Then the detail lines compute >> the >> >> result and make a PUSH to the Invoice marking a flag field (so no >> >> concurrency error is possible). Then an escalation executes at every >> >> minute on marked invoices, that computes the total.**** >> >> >> >> ** ** >> >> >> >> I hate using escalations for complex computations. Do you know any >> other >> >> way to achieve my objective without escalations?**** >> >> >> >> Jose M. Huerta >> >> Project Manager**** >> >> >> >> Movil: 661 665 088**** >> >> >> >> Telf.: 971 75 03 24**** >> >> >> >> Fax: 971 75 07 94**** >> >> >> >> <http://www.sm2baleares.es/>**** >> >> >> >> SM2 Baleares S.A. >> >> >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > >> > >> > >> > -- >> > >> > Jose M. Huerta >> > Project Manager** >> > >> > Movil: 661 665 088 >> > >> > Telf.: 971 75 03 24**** >> > >> > Fax: 971 75 07 94**** >> > >> > <http://www.sm2baleares.es/>**** >> > >> > SM2 Baleares S.A. >> > C/Rita Levi **** >> > >> > Edificio SM2 Parc Bit**** >> > >> > 07121 Palma de Mallorca**** >> > >> > <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> >> > <http://twitter.com/#!/SM2Baleares> >> > <http://www.linkedin.com/company/sm2-baleares> >> > >> > La información contenida en este mensaje de correo electrónico es >> > confidencial. La misma, es enviada con la intención de que únicamente >> sea >> > leída por la persona(s) a la(s) que va dirigida. El acceso a este >> mensaje >> > por otras personas no está autorizado, por lo que en tal caso, le >> rogamos >> > que nos lo comunique por la misma vía, se abstenga de realizar copias >> del >> > mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo >> de >> > inmediato.**** >> > >> > P Por favor, no imprima este mensaje ni sus documentos adjuntos si no >> es >> > necesario. >> > >> > >> _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"