As I remember, I have had to use PLAYBACK to do what I think you want. I wish there were a better way.
Bill Cook Kent WA USA ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 7:12 AM Subject: RE: Var Display on Form > 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/
