J
James Palmer
Guest
Can anyone explain to me why a find with no lock using the rowid doesn't refresh the value in the buffer even with -rereadnolock parameter enabled? We have a number of situations where records are updated on a GUI session, and on a CHUI (barcode reader gun) session almost at the same time. For example the CHUI session requests to pick an order, the GUI session authorises the order for picking and then the operative goes and picks that order. But the CHUI session isn't getting the updated record as it still has it in the buffer from the last time it was accessed. Progress support have told me that you need to find the record exclusive lock on the CHUI session to ensure it's not a dirty read. But we've had that code in place before and have had horrendous locking issues due to the numbers of users concurrently working. If we change the find to use an index rather than the rowid find then it refreshes the record in the buffer. But that's not realy a workable solution either as we know we have instances of this problem, but not where.
Continue reading...
Continue reading...