>I have a View which is opened with table buffering in the data environment of my form. The View has been modified but when I perform a SELECT statement on the contents of the View it does not show the modifications. I'm sure this is because I have not yet executed a TABLEUPDATE. In this scenario I don't want to commit the changes to the associated tables. Anyone know how I can extract the buffered data out of a view using a SELECT statement?

Lee

IMHO, you would be playing a dangerous game. You would be using data that does not really exist. If a user decids to rollback or Cancel the input you will have some real problems on your hands. Also consider if the data is only 1/2 entered when you try to retrieve it from the buffer -- your data will be incomplete.

Tom