Because buffering. A SELECT command will be executed against the temp file - DBF('view_alias'). After a TABLEUPDATE(), the results must be the same.


>Thanks Dorin
>
>I did end up doing that. But I am still curious why that works when SQL against the view ignores any changes made.
>
>Nick Mason
>>You can save the recno() into a local variable, execute a SUM command and then GO TO record number saved into variabile.
>>

>>LOCAL lnRecno
>>lnRecno = RECNO()
>>SUM ...
>>...
>>GOTO lnRecno
>>

>>
>>>Hi
>>>
>>>I have a view displayed on a grid.
>>>
>>>The user can amend values on the grid updating the view.
>>>
>>>I then want to add up one of the columns in the view but when I select the sum of one of the columns it doesn't reflect the changes made on the grid.
>>>
>>>Whats the best way to ensure I am adding up what the user can see.
>>>
>>>Nick Mason