Eric should be aware that if the view buffer is "dirty", the values pulled by a select statement won't reflect the uncommited changes. SQL SELECT operations on a view actually pull the values from the underlying table.
>SELECT Sum(MyField) AS Total FROM MyView INTO CURSOR curSum
>lnTotal = lnTotal + curSum.Total
>USE IN curSum
>
>HTH
>I have a view that I use to input data in a grid. In the amount field, valid method, I want to recalculate the totals by cumulating the amount in each record of the current view. The problem is that it makes me loose my current pointer.
>>
>>How can I achieve this?
Erik Moore
Clientelligence