How to check if table is locked or not.

rahul_jnk

Dear All,

Is there a way to find whether a table is locked before doing any update operation on it?

For eg before I go on updating the records in the Table MyREC, I would like to know before hand whether the table is locked or not

IF MyREC.FINDSET(TRUE, FALSE) THEN REPEAT
......
UNTIL MyREC.NEXT = 0

Thanks.

JJMc

Try to lock it yourself, if you get an error, then you can't. If you lock the table in a try function, you can catch the error to avoid to stop the process

rahul_jnk

Thank You @JJMc
That was what I did eventually. But I thought there could be a better way.

ktwoone

@JJMc @rahul_jnk Can you please elaborate how you used Try Function to identify the lock table issue?

JJMc

Write a Try function, and lock the table inside this funtion (procedure) like this TableX.Locktable(false).
If this function manages to lock the table, it'll return true, otherwise it'll return false. Then you can catch the error and do whatever you need to do.