Add 4gl/abl Support To Display Which User/connection Has A Record Locked

  • Thread starter Thread starter TheMadDBA
  • Start date Start date
Status
Not open for further replies.
T

TheMadDBA

Guest
Please add functions or statements to get the connection ID that has a record locked. Obviously the 4GL has access to this information when you try and lock a record without error handling (record in use by xxx on xxx). If you are writing proper code and trying to lock a record with NO-WAIT this information will not be displayed and people resort to looking through the _Lock table instead. It would be far easier to have something similar to this... if locked(tablename) then do: find _connect where _connect._connect-id = locked-by(tablename) no-error. /*--- display or log _connect info here ---*/ end,

Continue reading...
 
Status
Not open for further replies.
Back
Top