Jim, The fact that it's a computed column should not be relevant. Did you try my other suggestion?
However, I got the impression that the problem was in your detail section; if it's in the header then you need to refresh or open/close that table rather than the other one. The other thing that you could try is to add a RECALC TABLES before your RETURN. Regards, Alastair. ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Wednesday, November 19, 2008 12:38 AM Subject: [RBASE-L] - Re: table info not updating 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 To: RBASE-L Mailing List 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 ------------------------------------------------------------------------------ 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
