Forum Post: sql/odbc - update a record without locking table, possible ?

  • Thread starter Thread starter croute
  • Start date Start date
Status
Not open for further replies.
C

croute

Guest
Hello, When i update a record with "update pub.mytable set myfirstcolumn = 123 where pub.mytable.mysecondcolumn = 58945" The error is "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting table lock on table PUB.mytable." Other users are connected to this table with ABL and lock many records but not the one i want to update. Why ODBC need to lock the entiere table for update a single record ? Can i only lock the record and not the table ??? (sorry for mistakes, English is not my native language) Odbc connection on Windows, driver pgoe1024.dll Isolation level: serializable Openedge 10.2B05.

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