>>>I have a view I created but How do I refresh it, in other words; how does the refresh() command work
>>
>>Sergio, It depends on what you are doing.
>>In most cases with the views you issue REQUERY() which runs the View SELECT statement again. It discards current View cursor and creates the new one.
>>The REFRESH() function may be used for the updateable views to refresh the values from original tables only for those records which were not updated in the view.
>>
>>Nick
>
>I use the view inside a form. But when i call the form it gives me an error (doesn't find data). But when I call it for the second time it shows with no problem.
>
>Any idea why this is happening
>Sergio
Is your view in the Dataenvironment?
What exact message are you getting?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison