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?