[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Using -rereadnolock with ROWIDs

  • Thread starter Thread starter Jeff Ledbetter
  • Start date Start date
Status
Not open for further replies.
J

Jeff Ledbetter

Guest
Thanks. [quote user="George Potemkin"] ? 1 2 FIND bCust NO-LOCK WHERE ROWID (bCust) = prCust. When the record is already located in the ICB structure (in the client record pool - the -l parameter) then FIND BY ROWID statement does not even create a db request and _UserIO._UserIO-DbAccess is not incremented. No matter if the -rereadnolock is used or not.[/quote] What is the correct technique to ensure that the latest record is always gotten from the DB? Immediately follow it with a FIND CURRENT? We are trying to debug a situation (that we cannot readily duplicate) where it appears that a record that has been updated in one procedure is not re-fetched when the ROWID is passed to another procedure and a FIND is executed.

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