>>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
And they both re-exexcute the SQL that defines the view- REFRESH just might do some behind the scenes work with the results before they are posted in the open view... (only certain records for instance).
Erik Moore
Clientelligence