Alastair,
The one column in my Header table that is not recalculating is a computed column. Would that make a difference on how the PROPERTY commands work? Jim I tried the REFRESH statement and nothing different happened. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Tuesday, November 18, 2008 5:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: table info not updating I _think_ you need either: PROPERTY TABLE FormTableName REFRESH or PROPERTY TABLE FormTableName CLOSE PROPERTY TABLE FormTableName OPEN placed before your current property statements where FormTableName is the table associated with your detail section. Regards, Alastair. ----- Original Message ----- From: Jim Belisle <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Tuesday, November 18, 2008 10:27 PM Subject: [RBASE-L] - table info not updating I have the below EEP in a field for a form. Everything works except for the QuoteTotalAmount. I have checked to make sure the component ID is spelled right. If I go from the detail section where this EEP is located to the Header section and then back to the detail section, it updates. This is based on two temporary tables. RECALC VARIABLES SELECT (SUM(ItemExtPrice)), (SUM(ModelExtWgt)) INTO + vSubTotal INDIC ivSubTotal, + vTotalWeight INDIC ivTotalWeight + FROM tQuoteDetail WHERE QuoteID = .vQuoteID SET VAR vSurcharge = (.vSubTotal*0.065) SET VAR vFreightAmount = QuoteFreightAmount IN tQuoteHeader WHERE QuoteID = + .vQuoteID SET VAR vTotalAmount = (.vSubTotal + .vFreightAmount + .vSurcharge) PROPERTY QuoteTotalWeight TEXTVALUE .vTotalWeight PROPERTY QuoteSubTotal TEXTVALUE .vSubTotal PROPERTY QuoteSurcharge TEXTVALUE .vSurcharge PROPERTY QuoteTotalAmount TEXTVALUE .vTotalAmount RECALC VARIABLES RETURN Jim ________________________________ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 18/11/2008 11:23
