TMSFNCGrid calculations and fixed footer row

Since showing the sum of a column in the fixed footer row isn't possible when the grid is attached to a database (query) I have to figure something else out to accomplice that.
I try to use a Statusbar object for that purpose but how on earth do I calculate the sum of a column and put the result in a variable without getting an AV

tia Anske


You can add a fixed footer row and add calculations, but you'll have to first load all data in the grid using TMSFNCGridDataBaseAdapter1.LoadAllDataAndDisconnect, then afterwards configure the fixed footer row for the calculation