>I have a screen with Main File. I use Optimistic Table Buffering with views for all my files.
>The following happens: (My main File is SMA and view is V_SMA
>
>1. I make amendments to the view record
>2. I then do some validation processing on the views before I update
>
>Now if I say, do the following:
>SELE V_SMA
>COPY TO TEMP …. TEMP HAS MY adjusted view RECORDS
>
>But if I do the following:
>SELECT * FROM V_SMA INTO CURSOR TEMP……
>…. TEMP has my View records, BUT PRIOR to any adjustments being done.
>
>How come this different behaviour between my COPY TO and SQL SELECT statement ?
>
>Regards
>
>Gerard

Funny, we just ran into this. When doing a select against a view when the base table is not buffered it will basically just requery the view.

You can set the view buffering to row buffering and the underlying table to table buffering and then the select should work.

HTH