>Can someone please remind me how to get VFP to look at uncommitted changes on an optimistically buffered table.
>
>I want to sum a column in the table & am trying to use SQL wherever I can, but my command is not looking at the buffered data.
>
>help!
Robin,
Check WITH BUFFERING option in Select-SQL Help (new option in VFP9). However, my tests indicated that using this option may slow down queries, so may be you better off with DBASE syntax using SUM command rather than Select-SQL.
If it's not broken, fix it until it is.
My Blog