Page 1 of 1

SQLRefresh in MSQUERY

Posted: Tue 13 Oct 2009 07:13
by hmdsadeghian
Hi.how can Refresh Dbgrid every 5 second.? I wrote My update Query in SQL Refresh option.Because i wanna My datawarehouse quantity update every 5 second.because in network application every user work with datawarehouse and quantity was changed in every second.
but in sql refresh that i wrote this query my datawarhouse didnt update.
thanks

Posted: Fri 16 Oct 2009 10:33
by Challenger
The RefreshSQL property is used for record refreshing operations. You can call the RefreshRecord method to refresh record. If you want to perform full refresh call the Refresh method. Refreshing every 5 seconds you can implement manually using the TTimer component.