>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.

David,

Your SQL is returning the correct data, you are expecting the wrong data. The buffered data is not yet committed to the database and therefore SQL won't get it for you. This is in compliance with the standards for SQL. If you want the buffered data then you must TableUpdate first and then query.