Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Missing Record updates

Status
Not open for further replies.

oscarse

Programmer
Apr 9, 2006
99
CA
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?
 
find current worked

I tried this yesterday but wasn't using it properly

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top