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