>I have a grid on a form which displays a set of records from a file (with a filter set).
>There are 8 columns and variable rows, depending on the filter.
>I have put text fields below the grid showing the totals of each column. I get these totals with SQL select and fill an array. The problem is that I can't refresh these totals using the SQL select into the array until after a TABLEUPDATE.
>Is there an easier way to sum the values of the columns in the grid?
You could use parameterized table-buffered view as Grid.Recordsource. Then you use CALCULATE SUM... from Grid.Column.Text.InteractiveChange event, assuming that you will restore record pointer.
Edward Pikman
Independent Consultant