>Hi...I'm trying to show a running the total of a field in a grid (all the displayed records).
>
>The form uses buffering...the grid shows a records in the child table.
>
>I've got the running total in the main part of the screen. I can do a SQL-Select against the underlying tables and get the correct total,and display it...but then when I attempt to edit the buffered child table, either everything works, but the total doesn't update (because the underlying table hasn't been updated from the buffer) or I get a series of very nasty messages which appear to have something to do with the buffering. (When querying I query to a temporary cursor...which is not buffered).
>
>Any ideas?
>
>Many thanks.
>
>--- Larry Keyes
When you run SELECT-SQL you get values from underlying table, and when you run CALCULATE/COUNT/SCAN (i.e. Xbase commands) you get values from buffer. So, just choose what you need, probable the second case.
Edward Pikman
Independent Consultant