Subject Everything is Standstill when query is executed at server
Author R. S. Patil
Dear Friends,

I am using IB_query which does

select
*
from
<Stored Proc>(param,......);

it takes about 4 to 5 minutes to execute. While query being
executed the application appears
to be standstill even threaded timer event also not being
executed. The users are becoming impatient and are most
often are resetting machines (earlier they were using pdox
based application and progress bars were shown as process
advances)

is there any way to get periodic response while server is
executing the long running sp/query.

why application is not responding to any message from window
like timer, mouse move, keyboard
etc. etc.

R. S. Patil