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/
