I just ran into something and I was wondering if someone could explain why this works the way it does.

I have a parameterized local view 'MyView'.

I use the view, then select from it:

use MyView

Select * ;
    From MyView ;
    into cursor Temp

No problem, the Temp cursor shows all the records in MyView (there's only 2 records)

Now I append 2 records to MyView, and perform the same select. The resulting cursor (Temp) doesn't have the appended records? I browse MyView and they're in MyView but the select can't see them.

I tried a

use dbf('MyView') again in 0 alias TempCurs

, select against that get the same results.

What am I missing? I would think the select would find all the records