Hi Roi ---

Mind you, this is just a theory, but is the view table buffered? If so, the appended records would have negative record numbers and that *might* be a part of the problem.


>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