>What is the difference between REFRESH() and REQUERY() when using remote views? Right now I am using REQUERY() after I update the base table to make sure the info is correct.
>
>Thanks,
>Doug
Hello Doug,
The difference is that REQUERY() re-executes the view's SQL statement, discarding the existing cursor and creating the new one.
Refresh gets the new values for the records which haven't been updated in the view. With REFRESH(10, -6) you can retrieve the new data for 10 records starting with the record which is 6 rows prior to the current one. REFRESH works slower than REQUERY().
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