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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.