I'm doing some work on an legacy system written in 9.1C and I need to update a dynamic buffer that is in a no-lock state - so basically I need to upgrade it to exclusive-lock.
9.1D introduced the FIND-CURRENT method which makes this easy [e.g. hMyBuffer:FIND-CURRENT(EXCLUSIVE-LOCK)], but this is not available in 9.1C.
N.B. The table used by the buffer is dynamically obtained so static references aren't an option (e.g FIND CURRENT TABLEX EXCLUSIVE-LOCK).
Find-by-rowid is the best option. If not available this article explains a few other options:
Yes, FIND-BY-ROWID is supported!
Thanks for that, Mike :-)
This worked: hMyBuffer:FIND-BY-ROWID(hMyBuffer:ROWID, EXCLUSIVE-LOCK).
Sorry, one more question around 9.1C dynamic buffer limitations.
9.1C doesn't have the FIND-FIRST method. Is the only way to replicate this in 9.1C to create a FOR FIRST dynamic query? Any simpler options?