>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