Unable to edit data

[babeo]

Hello,
I am using MSQuery to change some data in MS SQL database, and strangerly some of them gone through, but certain records won't allow me to change (or only be changed at another time, another day), and the cursor is just hanging there forever until I close the application, what is the causes it hangs? Is this something with Record locking? Should I block all users first ? or else what should I do?
Thanks

 

[Krickles]

I assume you are working on a live database with a front-end app you didn't write. If so, the app is probably locking tables during database interaction. So yes, schedule a time to test your query when no users are logged into the system.

Krickles | 1.6180

 

[babeo]

Hi Kricles,
I think you are right, but since I can not tell if the record or table or database is locked (I think the set up is record locking only), it is bugging me. I want to find out if the record is locked and so I will avoid it and update another record. Is there any command to check which record or table is locked?
Thanks