tips:revmedia:v3i5a11

Uncommon Knowledge - WC_Joined_Locks%

Published ByDateVersionKnowledge LevelKeywords
Sprezzatura Ltd01 OCT 19912.1+EXPERTWINDOW_COMMON%, WC_JOINED_LOCKS%

@FM delimited array of record keys which have been successfully locked by the window. Note that this does not include the name of the table the lock was on. Note further that if any of the attempted locks fail (WC_WLOCKED% = 0 and WC_Joined_Keys%<13> = "") that this array will still contain all successful locks up to this point. Thus is an attempt was made to lock F1 F2 F3 and F4, and the lock failed on F3, WC_JOINED_LOCKS% would contain F1 and F2.

As of 2.1 this is the cause of a problem in expected behaviour when the window is exited. Since the window was unable to lock all needed records, it seems to overlook the fact that it has been able to lock some. Thus when escaping from a window, those records in WC_JOINED_LOCKS% when WC_WLOCKED% is 0 will remain locked. To avoid this simply code a post application to check whether all of these values have been unlocked

(Volume 3, Issue 5, Page 14)

  • tips/revmedia/v3i5a11.txt
  • Last modified: 2024/06/19 20:20
  • by 127.0.0.1