Ron, Oh So Close! Dr R> explained to me that global variables must be associated with the table you want them to recalc with. As well, they should be part of the variable list as you described here. Makes sense, I just assumed gobal was global --- shame on me <g>. Works like a charm.
Ben Petersen On 14 Feb 2002, at 14:29, Ron Rose wrote: > Ben > > In looking more closely at the rules for RECALC VAR page 340 of 5.5 ref > manual, "At least one form expression has the variable to the right of > the equal sign, which signifies a dependent expression" ztax = > (.zlinTotal * .ztax%) must be in the form expression list. RRR > > Ben Petersen wrote: > > > > Thanks Ron, but no go. > > > > Since I know the values are being set correctly by the sel > > statements, I just added some arithmetic to change the values of > > #2&3 at the end of the eep w/ another recalc var for good measure, > > but the form display of the those two vars did not change. > > > > Ben Petersen > > > > On 13 Feb 2002, at 13:52, Ron Rose wrote: > > > > > Ben, > > > In #2 and #3, the select is doing the calculation and placing the > > data. > > > Select sum into zlinetotal and then let the EEP calculate ztax > > and > > > ztotal so the dirty flag possibly is set. RRR > > > > > > Ben Petersen wrote: > > > > > > > > Hi all, > > > > > > > > Using RBW6.5+ > > > > An entry eep runs these three select commands: > > > > > > > > #1 > > > > SELECT (CTXT(t2.acct#)&'-'&t2.accountname) + > > > > INTO zdisp + > > > > FROM &ztblnm t1, gl_accounts t2 + > > > > WHERE t1.acctref = t2.acctref AND + > > > > t1.transerial = .zlineid > > > > > > > > #2 > > > > sel (sum(t2.LineTotal* ifeq(t1.IncTax,1,T5.TaxRate,0))) + > > > > into zTax + > > > > from ar_invoiceDtl t2, ar_invoice t1, SalesTax t5 + > > > > whe t1.tranid = t2.tranid and tranid = .zTranID > > > > > > > > #3 > > > > sel (sum(t2.LineTotal* (1+ifeq(t1.IncTax,1,T5.TaxRate,0)))) + > > > > into zTotal + > > > > from ar_invoiceDtl t2, ar_invoice t1, SalesTax t5 + > > > > whe t1.tranid = t2.tranid and tranid = .zTranID > > > > > > > > and "recalc var" follows. zDisp, zTax, zTotal are on the face of > > the > > > > form, all with identical properties. But only #1 (zDisp) is > > updated on > > > > entry to the field. I can trace the eep and watch all 3 values > > change > > > > in the debug window. > > > > > > > > I've got to believe I've missed something. > > > > > > > > Tia, > > > > > > > > Ben Petersen ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
