General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only