Jim, Computed columns in the table are not computed until they are saved. You could either save the row, and then GETPROPERTY caption or textvalue of a displayed DB Label or DB Edit control. Or you could get the value of each column referenced in the computed column expression, do the same calcuation, and update a static text or variable label with a PROPERTY command.
Bill On Tue, Oct 20, 2009 at 2:50 PM, Jim Belisle <[email protected]> wrote: > I am using a temporary table as the table when I edit my orders. > > I use variables on the form to show any changes to the Order (such as > subtotals, etc.) > > I use the PROPERTY commands (TEXTVALUE) on certain db edit fields to update > them. This works fine. > > My question is on columns in the temporary tables that are computed. These > would be for totals, etc. > > Are there any commands that will recalculate those computed fields? > > Since the other fields are updated as TEXTVALUES, is this possible? > > > > Jim > > > > PS. I have tried using the PROPERTY command to equal the subtotal and > total variables but to no avail. >
