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