David,

The SQL runs against the raw table not the buffered data, you can use a SCAN loopif you are doing something like summing the data. But SQL won't see the changes until you TableUpdate().

>We have a Visual FoxPro 5.0 application that has the typical one to many relationships among tables. All changes to this data by users are done through screens we have developed. The program buffers and updates all the data if any changes are made. The problem I have encountered is when the data is buffered (and changes to the data are made) and before the update is issued. If I execute a sql statement on this data before the update it returns the results of the data before any of the changes. If I browse the underlying buffered table of the sql it does have the correct data present. Why is the sql statement returning the wrong data?
>
> We have Novell 4.x, Windows 95.