>>>Most of the time when I have a form that does some data crunching I get an hour glass. I have this one particular form that when I do the data crunching my mouse disappears. I also have a wait window within the scan...endscan and this doesn't show either.
>>>
>>>Any ideas?
>>>
>>>Thanks,
>>>Paul
>>
>>If it's an ordinary wait window, it will pause until there's been a keypress or a mouse click. Do you have a WAIT WINDOW NOWAIT "your message"? That should stay on screen until you do a WAIT CLEAR.
>
>Yes, I have a NOWAIT. The point here is that the application is like frozen until the process is complete. The other thing I noticed is while the process is running the task manager says my application is not responding.
>
>Thanks,
>Paul
If the bulk of your processing is being done by a complex SQL statement(s), that's exactly what it looks like to the system, "not responding".