State Machine Scenario:
Process A: updates a record and commits the data with a release <table> within a local procedure and explicit transaction
Process B: is a status monitor using a DO WHILE TRUE LOOP
issue Process B will read the <table> the first time with the correct value but subsequent changes are not seen. I have tried:
Doing a find first <table> where ROWID(<table>) = ROWID(<Btable>) no-lock
finding within an explicit transaction
finding within an explicit transaction in a local procedure
or another module
Is there not another way to get the current value of this record?
Process A: updates a record and commits the data with a release <table> within a local procedure and explicit transaction
Process B: is a status monitor using a DO WHILE TRUE LOOP
issue Process B will read the <table> the first time with the correct value but subsequent changes are not seen. I have tried:
Doing a find first <table> where ROWID(<table>) = ROWID(<Btable>) no-lock
finding within an explicit transaction
finding within an explicit transaction in a local procedure
or another module
Is there not another way to get the current value of this record?