How to check if table is locked or not.

Answers

• Options

  JJMc Member Posts: 59

  2020-07-01

  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

  1
• Options

  rahul_jnk Member Posts: 61

  2020-07-01

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

  0
• Options

  ktwoone Member Posts: 4

  2021-06-30

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

  0
• Options

  JJMc Member Posts: 59

  2021-07-07 edited 2021-07-07

  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.

  0