>I have this app that monitors a client's site. The form has a timer running at 5 second intervals and all it does is do a select on a table on an NT network and if any results are received, updates the screen with a graph. Data is entered on another computer on the network. But I cannot get the SQL to return fresh data even if there is some without closing the table used (Flushing the local buffer?)every time before the SQL Select is run.
>
>Refresh is set to 10 secs, but even if I set it to 5 there is no update - until I close the database and reopen it.
>
>Why can't I keep it open and get the new data? Is it a VFP problem or a network one??
>
>Please help
>
>Bernard

You should get the new data. Are you refreshing your screen/grin after you do the select again?

Of course, this is a great use for a view. In your timer event you just need.

requery('myview')
thisform.refresh()

BOb