delete and update queries hung

[Tony]

I have some delete and update queries that when I ran them
I would get a msg "...deleting/updating ##### records..."
then it would sit there for a long time.

I had to close the database with NT task manager and open
it again.
If I look at the tables that I were deleting/updating
using the above mentioned queries the data were
deleted/updated.

Is there a way to fix this problem?

Thank you very much!!!!

 

[John Vinson]

I have some delete and update queries that when I ran them
I would get a msg "...deleting/updating ##### records..."
then it would sit there for a long time.

I had to close the database with NT task manager and open
it again.

This is an excellent way to cause irreversible corruption of your
database. DON'T DO IT! unless it's *really* hung (i.e. 30 minutes or
more).

If I look at the tables that I were deleting/updating
using the above mentioned queries the data were
deleted/updated.

Is there a way to fix this problem?

Doublecheck that your code isn't setting the SysCmd message and
failing to clear it. It sounds like the query is running OK and just
the message is hangning on for some reason.

 

[Tony]

Thanks John!!

Yes it's 30 minutes or more.

These are just queries, no codes, Just individual queries.

Thanks!