Refreshing data from a remote view

[xk120]

I have a query that uses a remote view. I need to check that all the data is updated before beginning some batch processes. I run the query and check the date on each record, if it has not been updated yet, then the program loops back and reruns the query in ten minutes. The problem is after it runs the first time the data doesn't change. The table doesn't seem to refresh. How can I force it to update the table with new data?

Thanks Bob

 

[DSummZZZ]

Look at the requery command. I believe it requeries the actual data instead of the buffered data.

Dave S.