>I am trying to create a screen that would show records that have missing data and need attention from the dispatcher. I want to use 'select' statements to compile this data from a couple of different sources. When the select is complete, I want the grid to update, and then the select reruns. This would go on continually. The problem is that I want the grid to be active while the select statement is running. I can do this if I have 2 seperate programs running, but I don't want to make the user click on 2 seperate icons (that would be stupid). Back in my main frame days we had 'phantom users' that would run in the background. Is there a way to make a program run continuesly, and have a form active at the same time?
>
>Thanks,
>Larry Morelli

Larry,

This is Cedric Harris from ATrade Investment Technologies, LLC in Houston, TX. I ran into the same requirement. The way to get what you want is to use either a local or a remote view. Since you are using VFP tables, you will need to use a local view and a mapped drive to the VFP tables that the user will see in his/her grid. The local view will be bound to the grid. You can use a timer to rerun your select statements at whatever interval you wish. When the timer reruns your select statement, you will call Requery("V_Your_Local_View_Name"). Since you created the local view from the VFP tables, the view will update. This will cause the grid to update, without blanking out your grid. When bind a VFP table to a grid and the rerun a query using that VFP table the grid will disappear. Using local views alleviate this problem.

Best of Luck,


Cedric,