>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
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