Hi!

Just run SPT query again. Message says what it says - not supported for SPT. You can use refresh() function for SPT, however, but only in case when you correctly defined cursor properties required for updating. Refresh() will just refresh information and will not show any new records added on the server by other users.

HTH.


>When use Remote view, we use
> =REQUERY('myview')
>to retrive data again for myview. When we use SPT, we got a message 'Function not supported for SQL pass through.'
>
>How can we retrive data again when we use SPT.
>
>Any suggestion?
>
>
>Jim