Ron, I thought you had it. But including those two vars so that they appear in the variable list made no difference. I know they are being evaluated, as I made a mistake the first time and got an error message.
Also, while not numeric, zDisp is handled identically to zTax and zTotal. The zDisp field refreshes on recalc var while the region has focus, though zTax and zTotal don't refresh until you click into another table. Thanks, 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/ > ================================================ 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/
