>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?
>
>TIA, Lee
>> As far as I know SELECT-SQL on buffered data will always go to source, i.e. retrieve data from table behind the view. So you can create cursor and try to collect data into it using regular XBASE algorithm, such as SKIP,SCATTER,INSERT.
Edward Pikman
Independent Consultant