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/
