>Hi All,
>
>Some colleagues are complaining about vfp using a lot of resource when running a batch progam or queries such that it's almost impossible to use other software like excel or word side by side. Is There a setting or something like that to prevent foxpro using all the recources?
You can experiment with putting DOEVENTS in your code. Usually the best place to put this is at the top of tight loops that are called frequently. Even if your VFP app in the background is using close to 100% CPU, the responsiveness of low-CPU foreground tasks like Word or Excel can still be quite good.
DOEVENTS does not help with single VFP commands that may take a long time to run (e.g. SELECT - SQL), unless you resort to tricks such as calling a UDF within the SELECT that in turn calls DOEVENTS.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up