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
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!