>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
Is the data entry system a VFP or FP app? What kind of table updating is done on those computers? Is your server directly querying the data tables or is it doing a requery of a view of those tables? You are really still running a multi-user app that should be able to see changes across the network as long as Table updates are performed. It could be a Network OS problem with setting for writing Dirty Buffers down to the disk.
Mark McCasland
Midlothian, TX USA