>>>I'm having this annyoing problem: I make a change to a local view, (Move/Add Fields), and the changes do not take effect, unless I exit out of VFP 5.0... What's wrong?
>>
>>Umm.. Are you calling TableUpdate() (or similar SAVE commands)? Is your view an updatable view? When you call the TableUpdate() are you sure you have the View selected?
>>
>>Hope this gives you some starting points.
>>
>>Barbara
>
>I'm not changing the data, but the layout of the view itself. In the View Designer, I change the Order By to a different view, and save changes to View. When I Browse the view, the sort order is still the same. But if I exit out of Foxpro, and Browse the view again, the order has indeed changed.
>Sorry, I should have been more explicit.
Sounds like you may have a copy of the view in memory, which VFP merely re-loads instead of re-querying. You might try the requery() command, or close all data and then USE the view again.
HTH
Barbara