>>>- If you're working with ActiveXs you may need to experiment with _VFP.AutoYield
>>>
>>>- It might help to put DOEVENTS calls in looping code
>>
>>I've been trying these.
>>
>>>
>>>- Never used it, but SYS( 2336 ) is related to MTDLLs
>>
>>Thanks, I'll investigate.
>>
>>>
>>>Can you tell what the long processes are, such as SELECT - SQL that's taking a long time to run? It's possible to work around some of those issues.
>>
>>Well I don't think it's the SQL, but, I'm pretty sure its related to the number crunching after that. What possible work arounds are you hinting at?
>
>For SELECT - SQL, you can add a dummy column which is the result of a UDF, which calls DoEvents e.g.
>
>SELECT ;
> SomeColumns ;
> , MyUDF( ) AS DummyColumn ;
> ...
>
>FUNCTION MyUDF
>
>DOEVENTS
>
>RETURN .T.
>
>
Interesting. I've never thought of doing this. Neat!
>Can you show us sample code of your number crunching? It is very complex/takes a long time to run?
Unfortunately I can't show you it as is. Basically it does a bunch of SQL to gather some base information into a cursor then it scans the cursor to generate some further stats. I'm not currently up on the details of it and tend to treat it as a "black box" and I don't really want to mess with that part of the code since I'd be responsible for it if it beaks :)