>>>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
>
>I understand the risks but here is may scenario:
>
>I have a form containing a list of items (stored in a View). When the user wants to add to the list a "MOVER" form is displayed. The available items for the "MOVER" form is populated from another table. The available items list should only contain items which are NOT already present in the View. Since the user can execute the "MOVER" form and add items multiple times before committing the changes to the View I need to know what is in the buffered View. Hence, my problem.
>
>I know I can walk the table, but I prefer to use a Select. Any suggestions?
I have not tried anything like this in a large scale. All I can offer is remember that bufferd records have a negative record number. Maybe you can use this somehow.
HTH,
Tom